testing whether the ActiveCell is in a given range
 

Is there a way to test whether the ActiveCell is in a given range?

For example, if a range named rngRedDog consists of the range D3:G6, how
could you test to see if the ActiveCell is in that range?

Thanks in advance,

Paul

testing whether the ActiveCell is in a given range
 

if Not Intersect(activecell,Range("rngRedDog")) is nothing then
' it is in a nmed range rngRedDog
end if

--
Regards,
Tom Ogilvy

"Paul Ponzelli" wrote in message
...
Is there a way to test whether the ActiveCell is in a given range?

For example, if a range named rngRedDog consists of the range D3:G6, how
could you test to see if the ActiveCell is in that range?

Thanks in advance,

Paul

testing whether the ActiveCell is in a given range
 

Ah, that's it. Thanks, Tom.