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!