software

Hi

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

Thank you
Emma

--
Message posted via www.officekb.com

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

quot;Emlou85 via OfficeKB.comquot; wrote:

gt; Hi
gt;
gt; Does anyone know a formula, which displays the cell reference of the cell
gt; that is currently selected?
gt;
gt; Thank you
gt; Emma
gt;
gt; --
gt; Message posted via www.officekb.com
gt;

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:
gt;=Cell(quot;addressquot;) will provide the absolute address of the current cell (e.g.
gt;$AG$500)
gt;
gt;gt; Hi
gt;gt;
gt;[quoted text clipped - 3 lines]
gt;gt; Thank you
gt;gt; Emma

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

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 quot;Name Boxquot;. This box
dispalys the name of the cell, object or range that is currently active.

HTH,
Elkar

quot;Emlou85 via OfficeKB.comquot; wrote:

gt; What I want to be able to do is enter a formula in say A1, which will display
gt; the cell reference of whichever cell I have selected with the mouse, so it
gt; will change each time I select a different cell.
gt;
gt; SVC wrote:
gt; gt;=Cell(quot;addressquot;) will provide the absolute address of the current cell (e.g.
gt; gt;$AG$500)
gt; gt;
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;[quoted text clipped - 3 lines]
gt; gt;gt; Thank you
gt; gt;gt; Emma
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...tions/200603/1
gt;

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.
www.mvps.org/dmcritchie/excel/ghosting.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Emlou85 via OfficeKB.comquot; lt;u19317@uwegt; wrote in message news:5d67f6d12c1c4@uwe...
gt; What I want to be able to do is enter a formula in say A1, which will display
gt; the cell reference of whichever cell I have selected with the mouse, so it
gt; will change each time I select a different cell.
gt;
gt; SVC wrote:
gt; gt;=Cell(quot;addressquot;) will provide the absolute address of the current cell (e.g.
gt; gt;$AG$500)
gt; gt;
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;[quoted text clipped - 3 lines]
gt; gt;gt; Thank you
gt; gt;gt; Emma
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...tions/200603/1

Yes I had noticed that there was a quot;Name Boxquot;.

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:
gt;Excel already does this. If you have the Formula Bar turned on (from the
gt;View Menu), then on the left side of that bar is a quot;Name Boxquot;. This box
gt;dispalys the name of the cell, object or range that is currently active.
gt;
gt;HTH,
gt;Elkar
gt;
gt;gt; What I want to be able to do is enter a formula in say A1, which will display
gt;gt; the cell reference of whichever cell I have selected with the mouse, so it
gt;[quoted text clipped - 8 lines]
gt;gt; gt;gt; Thank you
gt;gt; gt;gt; Emma

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