Is Range Between two Ranges
 

Kevin,

In the event below,

Not Intersect(Target,Range(rgeStart,rgeEnd)) Is Nothing

will return TRUE if the Target is between rgeStart and rgeEnd.

HTH,
Bernie
MS Excel MVP

"Kevin McCartney" wrote in
message ...
I'd like to find if the selected cell is between two ranges, does anyone
know the required code.

Private Sub xlApp_SheetSelectionChange(ByVal Sh As Object, ByVal Target As
Range)
Dim rgeStart As Range, rgeEnd As Range

Set rgeStart = Sh.Range("B15")
Set rgeEnd = Sh.Cells.SpecialCells(xlCellTypeLastCell)

End Sub

TIA
KM