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.

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.