Hey all, Thanks for your help. I am looking at some code to create
sheetlist, and have something that gives me a list. I now need to hav
it skip the first and last worksheet in the file. Is there any way t
do this? I tried doing a for...next loop, but couldnt get it to work.
Thanks again.

Sub UpdateSheetList()

Dim i As Long, sh As Object
i = 0
For Each sh In Sheets
i = i + 1
Cells(i, 1).Value = sh.Name
Next


End Su

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