Well done 'The Tamer' :wink:
Nevertheless, danno_mbk, if you want a macro do it for you, use the code below:
Public Sub ReplNullWithZero()
Dim c As Range
On Error Resume Next
Set c = Selection.SpecialCells(xlCellTypeBlanks)
On Error GoTo 0
If Not IsEmpty(c) Then
c.Value = 0
End If
End Sub
Ciao
