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:
[VBA]
If IsEmpty(Range("Range1:Range1_End")) Then
MsgBox "Empty Range"
Else
MsgBox "Not Empty"
End If
[/VBA]
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?