Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
How to replicate 1 range to muptiple ranges at once? | Excel Worksheet Functions | |||
Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K | Excel Worksheet Functions | |||
SUM using Three ranges. Two Comparisons and the SUM Range | Excel Programming |