If statement to determine if a cell is blank to return a MsgBox 1

[RyanScharfy]

I'm running the following, and cell A2 has no data, it's blank, and I'd like the message to pop up, but it's not happening. Any ideas?

' Validate that data is available
Sheets("AABS").Select
If IsEmpty(Range("A2").Select) Then
MsgBox "The combination you have chosen returns no data. Please review your choices and try again."
Else
' Start
Sheets("AABS").Select
End If

 

[fumei]

It is because you are selecting the cell. Try:

IsEmpty(Range("A2"))

Gerry
My paintings and sculpture