Hi
have a look at intersect for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Tim Coddington" schrieb im Newsbeitrag
...
What is the best way to define a range and then use it to test to see
if a
cell is within that range? Something like ...

dim rngMine as range
set rngMine = range("$D$3", "$D$4", "$E$3:$F$41")
If activecell.address in rngMine then ...