Calling the cell location of a defined name

[Tuberockin]

Hi Guys,

I was wondering whether there is a way to call the cell location of a defined name.

Eg. Cell A1 defined as Tree.

In another cell,
'cell reference of "Tree"' = A1

Hope you guys can help. Thankyou in advance

 

[Aladin Akyurek]

On 2002-03-16 02:56, Tuberockin wrote:
Hi Guys,

I was wondering whether there is a way to call the cell location of a defined name.

Eg. Cell A1 defined as Tree.

In another cell,
'cell reference of "Tree"' = A1

Hope you guys can help. Thankyou in advance

How about:

=CELL("address",Tree)

Aladin

 

[Tuberockin]

Yep Beauty,

Sorry, wasnt a real difficult one, just a little hazey at the moment. Had a very long day.

Thanks a lot Aladin