Can I print a list of all of the worksheets within a workbook?
 

You need a VBA macro to do this. Select the first cell in which
you want the list to appear, and run the following macro:

Sub AAA()

Dim Ndx As Long
For Ndx = 1 To ActiveWorkbook.Worksheets.Count
ActiveCell(Ndx, 1).Value =
ActiveWorkbook.Worksheets(Ndx).Name
Next Ndx

End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SRsonn" wrote in message
...