ExcelBanter - Replace blank cells with 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Replace blank cells with 0 (https://www.excelbanter.com/excel-programming/430025-re-replace-blank-cells-0-a.html)

Patrick Molloy

Replace blank cells with 0

With Range("A1:Z1").SpecialCells(xlCellTypeBlanks)
.Value = 0
End With

"scrabtree23" wrote in message
...
I need a code that will search a range (let's say A1:Z1) and will replace
any
blank cells with a zero (0).

All times are GMT +1. The time now is 09:56 PM.