Formula to show worksheet name

[Una Murphy]

Hi

I am looking for a function or formula that would specify
the worksheet name. The only way I can find to do this is
through hyperlink and it is not exactly what I am looking
for a this will not update the cell if the worksheet name
is changed. Is there such a function and if so how? I
would really appreciate your help as I would rather not
have to enter in all the worksheet names.

Thank you

Úna

 

[Ron de Bruin]

Hi

Look on Bob's site
http://www.xldynamic.com/source/xld.xlFAQ0002.html


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


Hi

I am looking for a function or formula that would specify
the worksheet name. The only way I can find to do this is
through hyperlink and it is not exactly what I am looking
for a this will not update the cell if the worksheet name
is changed. Is there such a function and if so how? I
would really appreciate your help as I would rather not
have to enter in all the worksheet names.

Thank you

Úna