Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding if the activecell is withing a named range
Hi, I have VBA code that is actived with the Worksheet_BeforeDoubleClick event and I want to find out if the cell that was double-clicked is within a named range. For example, if I have a range named Headers that is defined as A1:H3 and cell B2 is double-clicked I want to run the code otherwise I exit the sub. Any ideas on how to do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cleaning Specific Data withing a range from a cell | Excel Worksheet Functions | |||
ActiveCell in a Range? | Excel Discussion (Misc queries) | |||
selecting multiple cell in a roll that falls withing a range | Charts and Charting in Excel | |||
Activecell, not for cell,but for range? | Excel Discussion (Misc queries) | |||
ActiveCell.Copy Range("R3C27") | New Users to Excel |