List of workbook tabs
Donna,
Right click any sheet tab, view code and paste this in and run it for a list
of sheet names in Column A which you can then print
Sub SheetNames()
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
End Sub
Mike
"Donna" wrote:
I have a workbook with 100 sheets, named by employee. I want to get a
printout of the tab names so that I don't have to go through the entire list
to see if an employee already has a sheet. Is there a way to do this?
|