Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is the best way to define a range and then use it to test to see if a
cell is within that range? Something like ... dim rngMine as range set rngMine = range("$D$3", "$D$4", "$E$3:$F$41") If activecell.address in rngMine then ... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test if CELL is in RANGE | Excel Worksheet Functions | |||
logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
== How to test if a range var contains nothing | Excel Programming | |||
Test if Active Cell is in a named range | Excel Programming | |||
Test if Cell is within Range (name) | Excel Programming |