What do you want to replace them with? In short, what do you want to do?
HTH Otto
"wpw3" wrote in message
oups.com...
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