is it possible somehow to print sheets name from within one workbook. I have about 130 sheets and I would like to have them either in one file as a list or as a printout.
Thanks in advance,
Dim lngSheetCount As Long
Cells(1, 1).Value = "Sheet Name"
For lngSheetCount = 1 To ActiveWorkbook.Sheets.Count
Cells(lngSheetCount + 1, 1).Value = Sheets(lngSheetCount).Name