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

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


On Tue, 5 Oct 2004 12:10:21 +1000, "andym" wrote:

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,

nice and easy :)

thanks very much!!

andy m


"Myrna Larson" wrote in message
...
Just execute a Select statement, i.e. Sheets(2).Select


On Tue, 5 Oct 2004 12:10:21 +1000, "andym" wrote:

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