HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007
 

HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007
 

Sub ListWS()
Dim wS As Worksheet, lRow As Long
lRow = 1
For Each wS In Worksheets
Cells(lRow, 1) = wS.Name
lRow = lRow + 1
Next
End Sub


--

Regards,
Nigel




"goutam" wrote in message
...