Test to see if a cell is within a range

[Tim Coddington]

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 ...

 

[Frank Kabel]

Hi
have a look at intersect for this

 

[Bob Phillips]

Tim ,

You won't be able to set the range like that

Dim rngMine As Range
Set rngMine = Range("$D$3, $D$4, $E$3:$F$41")
If Not Intersect(ActiveCell, rngMine) Is Nothing Then
MsgBox "found"
End If


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tim Coddington]

Thanks for the help!

Tim ,

You won't be able to set the range like that

Dim rngMine As Range
Set rngMine = Range("$D$3, $D$4, $E$3:$F$41")
If Not Intersect(ActiveCell, rngMine) Is Nothing Then
MsgBox "found"
End If


--

HTH

RP
(remove nothere from the email address if mailing direct)