Test If Cell is Empty or Blank

TJE · Dec 15th 2006

I want to add an IF statement to my macro that will run only if a cell on the worksheet is not blank (empty). I know how to use the if statements but can't figure out how to test a cell for contents.

Richie(UK) · Dec 15th 2006

Re: If Statement Based On Cell Contents

Hi TJ,

How about :

Code

If Not Range("A1") = "" Then MsgBox "Its not blank!"

JayL · Dec 15th 2006

Re: If Statement Based On Cell Contents

I would try either:
[vba]IF Cell(x,y)=""[/vba]
Or
[vba]IF LEN(TRIM(cell(x,y))=0[/vba]

WOuld either of these work?

Dave Hawley · Dec 16th 2006

Re: If Statement Based On Cell Contents

If you mean truly empty/blank use

Code

Sub IsCellBlank()
    If IsEmpty(Range("A1")) Then
       MsgBox "Empty"
    ElseIf Range("A1") = "" Then
       MsgBox "Empty Text"
        If Range("A1").HasFormula Then
          MsgBox "Empty Text is the result of a formula"
        End If
    Else
      MsgBox "Contains data"
    End If
End Sub

Display More

TJE · Dec 18th 2006

Re: Test If Cell is Empty or Blank

That gives me what I need.

Thanks

Test If Cell is Empty or Blank

Participate now!

Share