View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TOMB TOMB is offline
external usenet poster
 
Posts: 25
Default Need group all sheets in a workbook

I have several workbooks that I will need to open and group all sheets
regardless of sheet name and number of sheets. I concidered something like:
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
but of course that is too specific to the sheet names and number of sheets.

Thanks in advance for the help!

- -TB - -