This works. Exactly what I wanted.
Thanks a lot saved a lot of hassle.
Sunny
"raypayette" wrote:
You would have to use VBE:
Sub SheetList()
For Each ws In Worksheets
i = i + 1
Cells(i, 1) = ws.Name
Next
End Sub
--
raypayette
------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=566968