ActiveCell

Sandy · Mar 13, 2008

I am trying to achieve

If ActiveCell In Range ("C22:K22,C24:K24") Then

but I require assistance with the correct syntax.

Thanks
Sandy

Ron Coderre · Mar 13, 2008

Try something like this:

IF Not Intersect (ActiveCell, Range("C22:K22,C24:K24")) is Nothing THEN

(Not really intuitive, is it?)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Sandy · Mar 13, 2008

Certainly is not.
Many thanks though Ron.

Sandy

Ron Coderre said:
Try something like this:

IF Not Intersect (ActiveCell, Range("C22:K22,C24:K24")) is Nothing THEN

(Not really intuitive, is it?)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Ron Coderre · Mar 13, 2008

Glad to help.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)