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

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


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


"fazeez01" wrote in message ...

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.


--
AlexJ
------------------------------------------------------------------------
AlexJ's Profile: http://www.excelforum.com/member.php...o&userid=27247
View this thread: http://www.excelforum.com/showthread...hreadid=467610