Code to 'unbundle' and array

R

Rob

I need help writing the code that unbundles an array of worksheets.

I have an application where upon completion prepares a two sheet-tab
summary and copies these to a new workbook. The problem I have is
when the user closes the newly created summary workbook and returns
the the original workbook, the two sheet-tabs are still 'grouped'.

Is there code to unbundle these two sheets when the user returns to
the original workbook, and opens to the 'report' sheet-tab?

Here is the code I use to take the two tabs and copy them to a new
workbook:

'**********copies to new workbook
Sheets(Array("Summary", "report")).Select
Sheets(Array("Summary", "report")).Copy

Thanks for any help,

Rob
 
D

Dave Peterson

Try removing the .select line. It's not necessary and it's causing your trouble.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top