Calling the cell location of a defined name

Tuberockin · Mar 16th, 2002, 03:56 AM

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 · Mar 16th, 2002, 04:00 AM

Quote:

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 · Mar 16th, 2002, 04:04 AM

Yep Beauty,

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

Thanks a lot Aladin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 16th, 2002, 03:56 AM	#1
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	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

Mar 16th, 2002, 04:04 AM	#3
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Yep Beauty, Sorry, wasnt a real difficult one, just a little hazey at the moment. Had a very long day. Thanks a lot Aladin