Re: ActiveCell by Ron
Ron
Thu Mar 13 14:49:22 CDT 2008
Glad to help.
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Sandy" <sandy_stephen@DELETEhotmail.com> wrote in message
news:eOIduFUhIHA.1408@TK2MSFTNGP03.phx.gbl...
> Certainly is not.
> Many thanks though Ron.
>
> Sandy
>
> "Ron Coderre" <ronREMOVETHIScoderre@bigfoot.com> wrote in message
> news:#drA0CUhIHA.200@TK2MSFTNGP02.phx.gbl...
>> 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" <sandy_stephen@DELETEhotmail.com> wrote in message
>> news:5B6BB6C6-B6CB-46A8-B998-C8BA24EA9FFB@microsoft.com...
>>>I am trying to achieve
>>>
>>> If ActiveCell In Range ("C22:K22,C24:K24") Then
>>>
>>> but I require assistance with the correct syntax.
>>>
>>> Thanks
>>> Sandy
>>
>>