| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I print a list of all of the worksheets within a workbook?
|
|
#2
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| Define list of worksheets | Excel Worksheet Functions | |||
| Print mult worksheets to Adobe | Excel Discussion (Misc queries) | |||
| What is the simplest way to print multiple worksheets? | Charts and Charting in Excel | |||
| print a list of worksheets and links | Excel Worksheet Functions | |||
Linear Mode
