Quote:
|
Originally Posted by gazzae
Quote:
|
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..
Quote:
For i = 1 To Sheets.Count
Worksheets(1).Cells(i, 1) = Worksheets(i).Name
Next i
|
|
Yep, I was trying to do some other stuff with the sheet names, and so needed them in variables, but your's does the the basic listing without needing the variables.