Excel already does this. If you have the Formula Bar turned on (from the
View Menu), then on the left side of that bar is a "Name Box". This box
dispalys the name of the cell, object or range that is currently active.

HTH,
Elkar

"Emlou85 via OfficeKB.com" wrote:

What I want to be able to do is enter a formula in say A1, which will display
the cell reference of whichever cell I have selected with the mouse, so it
will change each time I select a different cell.

SVC wrote:
=Cell("address") will provide the absolute address of the current cell (e.g.
$AG$500)

Hi

[quoted text clipped - 3 lines]
Thank you
Emma

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200603/1