VBA - Copying Multiple Worksheets into New Workbook as Values - Too Slow... [CROSS POST]

[bg18461]

In attempt to get more experts eyes on my query I cross-posted and wanted to do it correctly after i was politely told to do so:

Original Thread: http://www.mrexcel.com/forum/excel-q...-too-slow.html

If you can provide me help, i politely request that you respond in the thread linked above. Thank you.

I am trying to optimize my code below. It works but it is soo slow, it seems to slow down on the array copy and pastespecial areas. I believe this is because its doing a cell to cell paste method. These sheets have data as well as graphs that i want to retain on the new sheet, but i could select ranges for each each if that would speed up this procedure. Any thoughts on speeding up this bit of code...

Please Login or Register  to view this content.

[mikerickson]

Cross-post
http://www.ozgrid.com/forum/showthread.php?t=172853

Also, did the solution at
http://www.mrexcel.com/forum/excel-q...-too-slow.html
not work for you.


(Please read the link in my sig. about cross posting politely)

[bg18461]

Please respond in my cross post shown in the first thread, thanks.

[jeffreybrown]

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).