Return the Name Box/Current Cell Address

E

Ecnerlac

I would like to know how to program one cell to always return the valu
shown in the name box (the current cell designation of the cursor)
 
D

Dave Peterson

You could use a two step process:

First the formula:
=CELL("address")

But it'll only update when excel recalculates. Hit F9 to force it to recalc
when you want to rely on that value.
 
Top