Display the cell reference of the cell that is currently selected.

[Emlou85 via OfficeKB.com]

Hi

Does anyone know a formula, which displays the cell reference of the cell
that is currently selected?

Thank you
Emma

 

[SVC]

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

 

[Emlou85 via OfficeKB.com]

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.

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

Hi

[quoted text clipped - 3 lines]

Thank you
Emma

 

[Elkar]

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

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.

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

Hi

[quoted text clipped - 3 lines]

Thank you
Emma

 

[David McRitchie]

That formula will also change when you select a cell on another sheet,
another workbook.

I think this crippled formula may be responsible for some problems
with ghosted cells, so I personally avoid using it without the cell reference,
and without the cell reference is what you would need. That might not be
the cause of the problems it could be the default setting of the wheel button
or it could be something else altogether that causes ghosting problems.
http://www.mvps.org/dmcritchie/excel/ghosting.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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.

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

Hi

[quoted text clipped - 3 lines]

Thank you
Emma

 

[Emlou85 via OfficeKB.com]

Yes I had noticed that there was a "Name Box".

I have drawn a keyboard in excel. The user is then told to click on the note
E. I then have an If statement that says if cell A2 displays D1 (note E)
then to say 'well done that is correct' and if not then display 'wrong have
another go'. My problem is getting a formula in A2 which displays what has
been selected, so the If statement can work!

Emma

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

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

[quoted text clipped - 8 lines]