Creating list of sheet names

[trickdos]

Thanks for your help guys.

I am looking for a macro to cycle through the sheets and on the firs
sheet create a list of all the sheet names from the file. Any ideas?
I started some code, but I can't seem to make it work.

Thanks again for your help.

Bret

 

[Tom Ogilvy]

Dim i as Long, sh as Object
i = 0
for each sh in sheets
i = i + 1
cells(i,1).Value = sh.name
Next

 

[Anne Troy]

This macro creates a "Table of Contents". Try it out:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=120

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************