Return the Name Box/Current Cell Address

[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)

 

[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.

 

[Ecnerlac]

Thanks a million! That will do