Check if Range is Empty

[tonyrosen]

Mainly because I'm about complete with this.

Let's say we have a range defined in the worksheet as: Range 1
and, the end of said range would also be defined : Range1_End

I'm wanting to check to see if the cell(s) are empty.

Whenever I use:

If IsEmpty(Range("Range1:Range1_End")) Then
    MsgBox "Empty Range"
Else
    MsgBox "Not Empty"
End If

The macro tells me the range is NOT EMPTY every time.

How would I go about checking to see if it's empty if it tells me it's always populated?