Creating list of sheet names
 

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

--
trickdo
-----------------------------------------------------------------------
trickdos's Profile: http://www.excelforum.com/member.php...nfo&userid=940
View this thread: http://www.excelforum.com/showthread.php?threadid=26477

Creating list of sheet names
 

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

--
Regards,
Tom Ogilvy

"trickdos" wrote in message
...

Thanks for your help guys.

I am looking for a macro to cycle through the sheets and on the first
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.

Brett


--
trickdos
------------------------------------------------------------------------
trickdos's Profile:
http://www.excelforum.com/member.php...fo&userid=9405
View this thread: http://www.excelforum.com/showthread...hreadid=264774