Glad to help.
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Sandy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Certainly is not.
> Many thanks though Ron.
>
> Sandy
>
> "Ron Coderre" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:5B6BB6C6-B6CB-46A8-B998-(E-Mail Removed)...
>>>I am trying to achieve
>>>
>>> If ActiveCell In Range ("C22:K22,C24:K24") Then
>>>
>>> but I require assistance with the correct syntax.
>>>
>>> Thanks
>>> Sandy
>>
>>
|
Similar Threads
