Severely slow performance, Macro just stops

[captbluefin]

If we run the next snippet a new workbook opens instantly. If we paste to the new workbook it takes forever.

Please Login or Register  to view this content.

We would like to run the following code, but the performance is intolerable.

It will take 20 seconds to open the temporary workbook.

Then the paste takes 30 seconds.

If we run the macro without any breaks - the macro stops after the paste command - just as if an end command was run.

if we put breaks after every line in the macro, all the lines will run and the macro will continue. It just takes forever to open and paste into the temp workbook.
Then the macro just stops which is totally baffling. No crash. Just stops.

Please Login or Register  to view this content.

Attached is the "Parent" worksheet. Any blank workbook can be used for the temporary workbook.

We're glad to accomplish the task of saving one sheet from the parent workbook to a new workbook any way that works.

Going direct from the parent workbook to the WorkbookCreated from the parent Wb saves the time of opening an intermediate temporary workbook.

We could deal with the performance issues if we had to. When the Macro just stops as if an end command was issued - that's a problem.

All ideas are welcome.

[TMS]

Try:

Please Login or Register  to view this content.

https://docs.microsoft.com/en-us/off...el.sheets.copy

[captbluefin]

Changed

Please Login or Register  to view this content.

Another great learning experience. Another tool for the toolbox. Definitely not intuitive but does EXACTLY what we need. No intermediate sheet. Speedy enough.
The great piece of information is that by using sheet1.copy prior to saving the workbook, ONLY the copied sheet is saved, not all the sheets in the workbook. Quite the unexpected revelation.
Thank you TMS!!!!!!!!!!!!!!!!!!!!

[TMS]

You're welcome. Thanks for the rep.