Hi,

Am Fri, 25 Oct 2013 12:06:44 -0700 (PDT) schrieb :

is there any way to create a list of all the tabs of a workbook on one worksheet? thanks

try:

Sub Tabs()
Dim wsh As Worksheet
Dim i As Integer

For Each wsh In ThisWorkbook.Worksheets
i = i + 1
Sheets("Sheet1").Cells(i, 1) = wsh.Name
Next
End Sub


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2