Ungroup Sheets

[andym]

Dear All,

I wish to code in the ability to ungroup grouped worksheets in a workbook.

Something like:

Sheets(4,5,6).ungroup

for example...



any help would be appreciated.
andy m

 

[Myrna Larson]

Just execute a Select statement, i.e. Sheets(2).Select

 

[andym]

Myrna,

nice and easy

thanks very much!!

andy m