Thread: Extracting Worksheet names within a spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
raypayette raypayette is offline
external usenet poster
  
Posts: 1
Default Extracting Worksheet names within a spreadsheet

You would have to use VBE:
Sub SheetList()
For Each ws In Worksheets
i = i + 1
Cells(i, 1) = ws.Name
Next
End Sub


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=566968

Reply With QuoteReply With Quote