| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
active cell range
Does anyone know how to return the active cell reference (just as in the name
box) in a cell without using VBA is there a formula that does this or is there a way of refering to the active cell in an "if" formula in a cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
active cell range
First off if you are looking for a non-vba solution programming is not the
best forum to be in. That being said the only way to refre to the active cell is via VBA. There are no inherant functions that will do that. Additionally since moving the active cell does not cause a calculation to fire you can not effectively use a user defined funciton. Your best bet would be to use the selection change event in VBA... -- HTH... Jim Thomlinson "Atishoo" wrote: Does anyone know how to return the active cell reference (just as in the name box) in a cell without using VBA is there a formula that does this or is there a way of refering to the active cell in an "if" formula in a cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearly seeing active cell in a range | Excel Discussion (Misc queries) | |||
| Is Active Cell in a Range? | Excel Programming | |||
| How to set active cell range to an variable | Excel Programming | |||
| Active cell as range | Excel Programming | |||
| find range name for active cell | Excel Programming | |||
Hybrid Mode
