If statement referring to a blank cell

  • Thread starter Thread starter papa jonah
  • Start date Start date
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"
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF Statement 2
Extracting Values from text embedded in cell 10
Find Value and delete rows above 11
Refer to SQL statements globally 3
Fill out report based on rank from query 1
Sorting and searching 3
Copy cell to empty cells below. 3
Need help with IF function 4

Back
Top