E
Eva Shanley
You can run the following macro to get a list of sheet
names:
Sub SheetNames()
'Sheets Property Example
'This example creates a new worksheet and then places a
list of the active workbook's sheet names in the first
column.
Set NewSheet = Sheets.Add(Type:=xlWorksheet)
For i = 1 To Sheets.Count
NewSheet.Cells(i, 1).Value = Sheets(i).Name
Next i
End Sub
names:
Sub SheetNames()
'Sheets Property Example
'This example creates a new worksheet and then places a
list of the active workbook's sheet names in the first
column.
Set NewSheet = Sheets.Add(Type:=xlWorksheet)
For i = 1 To Sheets.Count
NewSheet.Cells(i, 1).Value = Sheets(i).Name
Next i
End Sub