How do I create a formula that displays the tab name in Excel?

[fazeez01]

[Ron de Bruin]

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


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


"fazeez01" <fazeez01@discussions.microsoft.com> wrote in message news:2A4DF27F-2BDE-4DE9-8B34-55CA583D36B3@microsoft.com...
>

[AlexJ]

You'll need this Excel add-in: http://xcell05.free.fr/downloads/Morefunc.zip

After you install it, just use the SHEETNAME() function.

Example: =SHEETNAME(1) would call the first tab in your workbook.

Hope this helps.