"Address" of current cell

[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

 

[Frank Kabel]

Hi Doug
try
=ADDRESS(ROW(),COLUMN())

Frank

 

[Peo Sjoblom]

Or slightly less typing

=CELL("address")

 

[Peo Sjoblom]

I might add that you have to press F9 to update to the active cell

 

[Doug Mc]

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