Forum Discussion
Formula to get address of selected cell on a worksheet
Essentially, you're looking to display the address that the name box shows. For example, let's say the formula to return the address of the active cell is in A1 and the active cell is Z100. The name box shows Z100 so the formula in A1 would return "Z100".
There's a few obstacles:
- theoretically, a formula capable of doing this would need to recalculate on selection change. A formula that's somewhat related to this is:
=INFO("ORIGIN")
The above cell returns the top-leftmost visible cell on the sheet.
Scroll down/scroll up, one must recalculate the results to get the origin.
The re-calc part is not the deal breaker though. The big obstacle is CELL and INFO cannot determine the active cell unless you want to return the address of the cell you're in. I believe you'd need vba to accomplish this task.
