See Bob's site http://www.xldynamic.com/source/xld.xlFAQ0002.html
A AlexJ Sep 14, 2005 #2 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.
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.