Ok, thanks again for indulging but I don't want any reference in the formula
to the current cell address, whether by name or otherwise. I want to use this
formula over many ranges. Is this possible? It's kinda like the cell asking
itself "=who am I?"
--
Creator


"CLR" wrote:

Yes, if you first give A1 a RangeName.........Insert Name Define.....type
in say, MyCell......

then this formula, anywhere, will return $A$1.........

=CELL("address",MyCell)

Vaya con Dios,
Chuck, CABGx3





"Creator" wrote:

Thanks for your response.

Can it be done without A1 appearing in the formula?
--
Creator


"CLR" wrote:

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator