ActiveCell

S

Sandy

I am trying to achieve

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

but I require assistance with the correct syntax.

Thanks
Sandy
 
R

Ron Coderre

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)
 
S

Sandy

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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activecell problem 1
CUMIPMT 0
help with formula 4
macro to select a range from a set cell to a specified cell 6
need formula help 2
how do I control autofill to do my progression? 2
Desperately need help with a formula 2
If condition for Blank Cell 4

Top