View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Creating a Sheet Index of all Excel Worksheets

Hi,

You may download and install the following addin -
http://www.download.com/Morefunc/300...-10423159.html. After
installing the addin, use the sheetname function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"K Smith" <K wrote in message
...
I have been trying find information on creating an Index of all worksheet
tabs, within a workbook, that will continually update with changes to the
tabs. I have tried through the code option, but I am clearly out of my
element here........