Thread: HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
  
Posts: 735
Default 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
...


Reply With QuoteReply With Quote