view list of worksheets contained within a workbook

P

Peo Sjoblom

Right click one of the sheet tab arrows at the left hand side
Only other option is to us VBA (macro)
 
G

Gord Dibben

A macro to list the sheets on a new worksheet.

Private Sub ListSheets()
'list of sheet names starting at A1
Dim Sh As Worksheet
Dim Rng As Range
Dim i As Integer
Worksheets.Add
Set Rng = Range("A1")
For Each Sh In ActiveWorkbook.Sheets
Rng.Offset(i, 0).Value = Sh.Name
i = i + 1
Next Sh
End Sub


Gord Dibben Excel MVP
 
J

JonM4

michael said:
how do i view list of worksheets contained within a workbook in excel?
Click to expand...

You can also click on "File", drop to "Properties" and then click on the
"Contents" tab to see the list of worksheets
 
Top