Multiple Named Worksheets. Need to make a list of ALL the names on ONE worksheet

Good morning everyone!

I have a file that I have over 90 customer worksheets. I would like a list of all the customers that I have a worksheet for. I'm sure there is a way to make a new workbook with all the names of the worksheets that I have.

Can anyone help with this? Greatly appreciated and would save me a lot of time!!

Almost sounds like you need a program called ListMaker which can browser hard drive folders and makes a list of the files it finds (can be set to limit only certain types like .xls) And thenonce list is made copy/paste into Cell B and add Customer names manually into Cell A.

http://www.novatone.net/software/ListMaker.htm

(I am in no way or means connected to the above program, I just happened to have used it previously).

The girl that previously made this file didn't have a list of the customers. She just added a worksheet with a name at the bottom and copied the form to each customer worksheet.

This macro will list all tab names in a workbook.

List will be added in the active sheet of workbook starting at cell A1 then A2 ..... An

Option Explicit

Sub ListOfTabs()
Dim i As Integer
For i = 1 To Sheets.Count
Cells(i, "A") = Sheets(i).Name
Next i
End Sub

Alf

macro does not work

Works for me.

Alf

I am getting a run time error and debugger starts

Select one sheet and run macro "ListOfTabs"

Alf

Seems there is a problem uploading files. I'll have another go at it.

Alf

Where do you put this code?

Developer tab -> "Visual Basic" -> "Insert" -> "Module" and paste code in the new "windows" that opends (check uploaded file as well).

"Option Explicit" = "Forces explicit declaration of all variables in a file, or allows implicit declarations of variables." For a more comprehensive explanation see link

http://msdn.microsoft.com/en-us/library/y9341s4f.aspx

Alf