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