MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Putting zeroes in blank cells in a macro


Posted by Bill Mahoney on February 14, 2002 10:43 AM

Hello, i am looking for a way to search a range of cells to see if they have a value and if one doesn't to enter a zero. Any help would be appreciated.

Regards,
Bill Mahoney
New York, NY


Posted by Mark W. on February 14, 2002 12:24 PM

Sub Macro1()
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "0"
End Sub