| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active cell is within a specific range
I need to check to see if the activecell is within a
particular range. Lets say I want to see if the active cell is within range "A1:F20". How do I do this? Thanks Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active cell is within a specific range
Todd,
Use the Intersect method. For example, If Application.Intersect(ActiveCell,Range("A1:F20") Is Nothing Then ' active cell not in range Else ' active cell in range End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... I need to check to see if the activecell is within a particular range. Lets say I want to see if the active cell is within range "A1:F20". How do I do this? Thanks Todd Huttenstine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a specific row number active from a cell entry | Excel Discussion (Misc queries) | |||
| to change the macros as per active cell and range | Excel Discussion (Misc queries) | |||
| Show value from specific column based on location of active cell | Excel Discussion (Misc queries) | |||
| use active cell to determine range | Excel Discussion (Misc queries) | |||
| Clearly seeing active cell in a range | Excel Discussion (Misc queries) | |||
Linear Mode
