IsEmpty - what's the opposite?

  • Thread starter Thread starter Theo
  • Start date Start date
T

Theo

This works great -

If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then ....

I need the same statement, but "not empty" - been searching, but can't find
it!
Any help appreciated!
 
Theo,

how about Not IsEmpty?

If cll.Value = "R" And Not(IsEmpty(cll.Offset(0,2))) Then

HTH,

Conan
 
Soooo close... Try Not IsEmpty...

If cll.Value = "R" And Not(IsEmpty(cll.Offset(0, 2))) Then ....

I like adding in the extra quotes.
 
That did the trick!
Thank you Jim
T

Jim Thomlinson said:
Soooo close... Try Not IsEmpty...

If cll.Value = "R" And Not(IsEmpty(cll.Offset(0, 2))) Then ....

I like adding in the extra quotes.
Click to expand...
 
Dim cll As Range
For Each cll In Selection
If cll.Value = "R" And Not IsEmpty(cll.Offset(0, 2)) Then
'do something
End If
Next


Gord Dibben MS Excel MVP
 
Back
Top