Printing Tabs

[Kathy@ACL]

I would like to print a list of the tab names without printing the whole
document. Can anyone help me?

 

[Gord Dibben]

Kathy

You will need a macro.

''list of sheet names in a workbook - placed on a new worksheet
Sub ShowNames()
Set wkbkToCount = ActiveWorkbook
iRow = 1
With Sheets.Add
For Each ws In wkbkToCount.Worksheets
.Rows(iRow).Cells(1).Value = ws.Name
iRow = iRow + 1
Next
End With
End Sub


Gord Dibben Excel MVP