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

Hi

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

Thank you
Emma

--
Message posted via http://www.officekb.com

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

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

"Emlou85 via OfficeKB.com" wrote:

Hi

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

Thank you
Emma

--
Message posted via http://www.officekb.com

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

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

Display the cell reference of the cell that is currently selec
 

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

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

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

"Emlou85 via OfficeKB.com" <u19317@uwe wrote in message news:5d67f6d12c1c4@uwe...
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

Display the cell reference of the cell that is currently selec
 

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

Elkar wrote:
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]
Thank you
Emma

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