For a formula only partial solution:

=CELL("Address")

But this will only update when a calculation occurs - not when the cell is
selected. .


--
Regards,
Tom Ogilvy



"cbre_bryork" <cbre_bryork@discussions.microsoft.com> wrote in message
news:70534EAD-C6AB-4A49-BE12-C43E7A05C206@microsoft.com...
> Is there a function that I could place in cell A1 that will return
> information on whatever cell is selected in on the spreadsheet? So for
> instance, if the current cursor position is in cell D3, I would like cell
A1
> to display "D3". And if I move the cursor to cell E5, I would like cell
A1
> to display "E5"