See if cell is in a range

[Dan Rositer]

How can I check to see if the ActiveCell is in a give Range?
VBA solution...

Dan

 

[Trevor Shuttleworth]

Dan

check the Help for Intersect

For example (not tested):

If Intersect(ActiveCell, Range("A1:C20") Is Nothing Then
MsgBox "Not in Range"
Else
MsgBox "In Range"
End If

Regards

Trevor

 

[Dan Rositer]

Thanks Trevor, that works...Intersect... gotta remember

Dan