If Range("F3").Value = vbNullString Then Range("F3").Value = 0
Code:If Range("F3").Value = vbNullString Then Range("F3").Value = 0
Try
Code:Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "F3" And Target.Value = "" Then Application.EnableEvents = False Target.Value = 0 Application.EnableEvents = True End If End Sub