"Address" of current cell

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
 
D

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
 
F

Frank Kabel

Hi Mel
neither ROW() nor COLUMN() are valid in your code. Try either Peo's or
my solution for this
 
Joined
Oct 9, 2017
Messages
1
Reaction score
0
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
>
>
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top