On Friday, October 25, 2013 3:14:51 PM UTC-4, Claus Busch wrote:
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

works great, thank you Claus. One more thing, in the adjacent column I would like to reference data in a specific cell from the corresponding tab. thanks again.