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

C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top