Replacing null with Zero in Excel

[derekstewart]

I would like to replace empty cells in excel with zero. Anyone know how to do this? Thanks.

 

[Jooky68]

if range("whatever cell&quot.value="" then range("the cell&quot.value=0

but im sure there is a much easier way to do this

 

[xlbo]

Select the area
CTRL+F
Leave it blank and select "Entire cells Only"
Click replace
Enter 0
Rplace all

or being as we are in the VBA forum

Range("A1:A100&quot.Replace What:="", Replacement:="0", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244