View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Loomah Loomah is offline
external usenet poster
 
Posts: 18
Default 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