If statement referring to a blank cell

P

papa jonah

I want to put an if statement in code that will say something like

If a1 is blank then

blah blah blah

end if

I can not seem to figure out how to refer to "blank"
 
G

Gord Dibben

papa

Sub blank()
If Range(A1").Value = "" Then
MsgBox "blah, blah, blah"
Else: MsgBox "halb, halb, halb"
End If
End Sub


Gord Dibben Excel MVP
 
Top