Re: FInd the intersection
Intersect method can be used in VB. It's something like this...
If Intersect(Selection, Range("A10:D10")) Is Nothing Then
MsgBox "Your Selection is not in the range"
MsgBox "Your selection is within the range"