Search and Replace Blank Cells
 

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

Search and Replace Blank Cells
 

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

Search and Replace Blank Cells
 

Maybe...
Cells.Replace What:="", Replacement:=0, LookAt:=xlWhole, MatchCase:=False



wpw3 wrote:

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

--

Dave Peterson