IsEmpty - what's the opposite?
 

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!

IsEmpty - what's the opposite?
 

Theo,

how about Not IsEmpty?

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

HTH,

Conan






"Theo" wrote in message
...
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!

IsEmpty - what's the opposite?
 

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

RBS


"Theo" wrote in message
...
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!

IsEmpty - what's the opposite?
 

Soooo close... Try Not IsEmpty...

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

I like adding in the extra quotes.
--
HTH...

Jim Thomlinson


"Theo" wrote:

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!

IsEmpty - what's the opposite?
 

That did the trick!
Thank you Jim
T

"Jim Thomlinson" wrote:

Soooo close... Try Not IsEmpty...

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

I like adding in the extra quotes.
--
HTH...

Jim Thomlinson


"Theo" wrote:

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!

IsEmpty - what's the opposite?
 

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


On Thu, 24 Jan 2008 14:09:55 -0800, Theo wrote:

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!