Isempty syntax

[bobkap]

I cannot seem to figure out how to use range with cells when using the Isempty function. Using the code below works fine. But I want to use cells instead of range and every thing I've tried bombs out.

For example something like 'If IsEmpty Range(cells(1,1), cells(1,1)) = True Then' never works. Or, if I delete the range completely, adjust the parens and go with just the cells. That doesn't work either.

Are we not supposed to use the cells function with isempty? Or, is my syntax just wrong?

If IsEmpty(Range("A1")) = True Then
MsgBox "Cell A1 is empty"
Else
MsgBox "Cell A1 is NOT Empty"
End If

 

[Micron]

Within the last day or two I read that Cells is a property of a range; it's not an object - thus you can't use IsEmpty on it.
EDIT - but this works
IsEmpty(Cells(1,1))

and so does this

IsEmpty(Cells(1,1) & ":" & cells(1,1))

Don't forget that it only takes one cell in a range to make it False.

 

[bobkap]

Within the last day or two I read that Cells is a property of a range; it's not an object - thus you can't use IsEmpty on it.
EDIT - but this works
IsEmpty(Cells(1,1))

and so does this

IsEmpty(Cells(1,1) & ":" & cells(1,1))

Don't forget that it only takes one cell in a range to make it False.

THANKS very much!!

 

[bebo021999]

Range ("A1") or Range(Cells(1,1),Cells(1,1)) exact the same
also
Range ("A1:B1") or Range(Cells(1,1),Cells(1,2)) exact the same
But, if using ISEMPTY with range of cells (more than 1 cell), its problem. It require loop for each cell.
I tried to test as below image:

 

[Micron]

Not sure what post 4 means but I can say that if A1 and A2 are as follows ( or both contain TEST, or only A1 contains TEST)

TEST

?IsEmpty(Cells(1,1)& ":" & cells(1,2)) returns
False