"Address" of current cell

  • Thread starter Thread starter Doug Mc
  • Start date Start date
D

Doug Mc

Is there a function that will return the "address" of the active cell?
In other words, if I'm on cell G9, it there a function I can use that will
return 'G9?'

TIA
Doug
 
Thanks folks.
I knew there had to be a way. (I thought I looked in Help for "Address",
but I guess I didn't.)

Doug
 
Hi Mel
neither ROW() nor COLUMN() are valid in your code. Try either Peo's or
my solution for this
 
Peo Sjoblom said:
Or slightly less typing

=CELL("address")

--

Regards,

Peo Sjoblom

"Frank Kabel" <[email protected]> wrote in message
news:[email protected]...
> Hi Doug
> try
> =ADDRESS(ROW(),COLUMN())
>
> Frank
>
> Doug Mc wrote:
> > Is there a function that will return the "address" of the active
> cell?
> > In other words, if I'm on cell G9, it there a function I can use that
> > will return 'G9?'
> >
> > TIA
> > Doug
>
>
Click to expand...
Just a note: Just tried both Frank and Peo's solutions; Frank's solution is required if you don't want the cell reference to move around when you click new cells. Cheers
 
Back
Top