Hello
i have been able to search and replace for #N/A:
Cells.Replace What:="#N/A", Replacement:=0, LookAt:=xlWhole,
MatchCase:=False
But I am not clear how to do the same for Blank or empty cells.
Any suggestions?
Thank you
W
Hello
i have been able to search and replace for #N/A:
Cells.Replace What:="#N/A", Replacement:=0, LookAt:=xlWhole,
MatchCase:=False
But I am not clear how to do the same for Blank or empty cells.
Any suggestions?
Thank you
W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks