Printing Tabs
 

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

Printing Tabs
 

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

On Mon, 5 Dec 2005 09:01:02 -0800, Kathy@ACL
wrote:

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