Forum Discussion
Formula to get address of selected cell on a worksheet
Hi, I'm looking for a formula to get the currently selected cell within a worksheet. No VBA or macros since my client has that disabled. Not the last cell edited since an edit may not occur. ...
Unfortunately, CELL("address") will only give the most recent edited cell and not the selected cell.
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.