Create worksheet index

  • Thread starter Thread starter index
  • Start date Start date
I

index

Hi there,

Is there anyway I can user a macro to create an index of all the
worksheets in a workbook?

Ideally it'll create a worksheet at the front of my book listing the
names of the worksheets which follow in the same book?

Can anyone help please?
 
Here's a quick and dirty that might get you started

'-----
Option Explicit
Sub makeIndex()
Dim shNum As Integer
Worksheets.Add before:=Sheets(1)
For shNum = 2 To Sheets.Count
Range("A" & shNum - 1).Value = Sheets(shNum).Name
Next
End Sub
'-----

HTH
Anders Silven
 
Back
Top