Macro to Fill empty cells with 0 (zero) number

[ropbasuel]

Hi all,

I have a Excell file with 3 worksheets on it. On the Worksheet2 I have a big table from (A1:Q90975). In this table I have some empty cells that I would like to, instead of being empty, have 0 (zero number) on it.

Can someone give me an hint on how to do this with a macro?

Thanks

 

[njimack]

You can do this with a single line of code...
Range("A1:Q90975").SpecialCells(xlCellTypeBlanks) = 0

 

[ropbasuel]

Thank you so much! Never thought it was so simple!

Regards