Grouping Sheets in VBA

J

John Pierce

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
 
Top