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