Forum Discussion
Formula to get address of selected cell on a worksheet
Very well explained, Patrick2788
As an addition, in case jhbrooks is just looking to return the address of the cell he/she's in, it is simply using:
=CELL("address")
But as perfectly explained by Patrick, this is something not "dynamic". It will simply return the reference of the cell wherever this formula is written and be left there, but maybe that is what you want...
What I meant - define the name and use it in formula as
Initially that will be circular reference. Now select any cell and press F9
Select another cell and F9
That's many years old solution, if we may consider it as solution. Perhaps something else exists except VBA, but I don't know.
Googled a bit and fount it in this Formula that returns address of the active cell. | MrExcel Message Board year 2009 discussion. Used that few years ago, that's why remember. However not very suitable .