Check if a range is inside another
Hi Rafael
This will give you a start
;-)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target, Range("myrng")) Is Nothing Then
MsgBox "ranges intersect"
Else
MsgBox "Ranges Don't intersect!"
End If
End Sub
Rafael Sobral wrote in message
...
Hi,
What options do I have to check if the target range of a
SelectionChange event is inside another?
Rafael
|