DQ1,

Cells.SpecialCells(xlCellTypeBlanks).Value = 0

HTH,
Bernie
MS Excel MVP


"DQ1" wrote in message
...

Mental block. Isn't there any easy way to fill all empty cells with
"0"'s?


--
DQ1
------------------------------------------------------------------------
DQ1's Profile: http://www.excelforum.com/member.php...o&userid=26841
View this thread: http://www.excelforum.com/showthread...hreadid=401137