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" <[email protected]> wrote in message news:[email protected]...
>

[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.