View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Pierce John Pierce is offline
external usenet poster
 
Posts: 93
Default Grouping Sheets in VBA

When I record the action of grouping all the sheets I get the
following.
I would like a macro that I could use to quickly group all sheets in a
workbook that will work with different numbers of sheets. No special
conditions to look for and no particular operations to perform.

Sheets(Array"Sheet1", "Sheet2", "Sheet3", "Sheet4", "Sheet5",
"Sheet6")).Select Replace:=False