Code to 'unbundle' and array

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
Try removing the .select line. It's not necessary and it's causing your trouble.
 
Back
Top