| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if cell address is within a range of cells
It's late and I'm hitting a wall.
I need to determine if the activecell is within a range of cells. I've tried: if activecell.address = range("A16:C40") then.... but I get a type mismatch. I'm can't find what I'm looking for in the VBA help, but I'm probably not asking the right question. Will someone help a novice, please??? TIA, Rich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine cell address of last entry in a row | Excel Discussion (Misc queries) | |||
| How to determine the column letter from Cell address | Excel Worksheet Functions | |||
| address command for a range of cells, not one cell | Excel Discussion (Misc queries) | |||
| Determine if Cell Address is within a Range | Excel Worksheet Functions | |||
| Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
![SteelDetailer[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
