Forum Discussion
Formula to get address of selected cell on a worksheet
Close solution is to use in formula INDIRECT( CELL("address") ), but you need to press F9 or recalculate by other way every time when another cell is selected.
We speak about INDIRECT( CELL("address") ). After the refresh (F9) it returns the value from the selected cell, aka cell in focus. Doesn't matter it is last edited or not, any focused cell.
If we are on last edited cell when F9 is not required, it is in focus by default.
And yes, without F9 it doesn't work with selected cell.
SergeiBaklan Thank you for the clarification. Requiring the F9 to refresh doesn't meet the criteria so I missed it in my read of your first answer.
I also had found that old solution but it didn't fit this need is why I asked the question.
I don't know other solutions, sorry. VBA or such kind of trick.