[gazzae]

Originally Posted by Simon M

If you created a Module and add this code to it, the sheet names will appear in the first column on Sheet1.



It also creates a Macro called Sheetname that can be run to update the list if any are added or taken away.

It's basic, but does the job.

Complicated!

This does the same..

For i = 1 To Sheets.Count
Worksheets(1).Cells(i, 1) = Worksheets(i).Name
Next i