Replace empty cells with zero in a range

**Snoopy2003** · 11-23-2012, 05:48 PM

Hello,

I wish to replace empty cells values with zero in a defined range.
I tried to use find & replace (VBA) but it did not work (cannot find empty cells).

I found the following solution but it takes a lot of time to execute.

Is there any solution to this that will run faster (like find & replace) ?

Please Login or Register  to view this content.

Thank you for your help

**TMS** · 11-23-2012, 06:08 PM

Why don't you just select the range and then do a Replace all blank cells with zero. Record a macro while you do it.

If you don't get "blank" cells replaced with 0, they're not blank cells.

Regards, TMS

**Snoopy2003** · 11-23-2012, 06:19 PM

Hello,

Thank you for your answer.
I tried it before but did not find any blanks.
I figured now that there were spaces in all the "blank" cells.
I will use find & replace.

Thank you for your help