Sheets in an excel file.

[Steven]

Is there a way to return to a list in a worksheet the names of all the Sheets
in an excel file? I have a file with 50 sheets and I want to have them in a
list like a table of contents sheet, but I dont want to do it manually if
possible.

Thanks for your help.

Steven

 

[Dave Peterson]

You can find some code also at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

He actually builds the table as hyperlinks--so you can click on them.

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Mark]

Hi Steven,

You should have a look at Naigator Utilities at www.robbo.com.au (free
download) - an add-in for Excel which helps you find your way around large
workbooks.\\regards
Mark