Can I link a cell to reflect a worksheet name?
 

Is it possible to have the value in a cell be linked to the name of a
worksheet? In other words, if a worksheet is named "Plan 1" can I link a
cell to that name so that if I change the worksheet name to "Plan 7" the cell
will also now say "Plan 7"?

Hi

See Bob's page about this
http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Regards Ron de Bruin
http://www.rondebruin.nl



"bkester" wrote in message
...
Is it possible to have the value in a cell be linked to the name of a
worksheet? In other words, if a worksheet is named "Plan 1" can I link a
cell to that name so that if I change the worksheet name to "Plan 7" the
cell
will also now say "Plan 7"?

Take a look at

http://www.mcgimpsey.com/excel/formu..._function.html



In article ,
"bkester" wrote:

Is it possible to have the value in a cell be linked to the name of a
worksheet? In other words, if a worksheet is named "Plan 1" can I link a
cell to that name so that if I change the worksheet name to "Plan 7" the cell
will also now say "Plan 7"?

Thanks for the help. It is most appreciated!



"bkester" wrote:

Is it possible to have the value in a cell be linked to the name of a
worksheet? In other words, if a worksheet is named "Plan 1" can I link a
cell to that name so that if I change the worksheet name to "Plan 7" the cell
will also now say "Plan 7"?