C
Chip Pearson
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
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