Macro running slowly, copy/paste values only from one workbook to another

I created a macro that will copy all the worksheets from one workbook and save as values only into another workbook. It works, but it is a little slow. I am doing some looping and wondering if maybe I can consolidate some of the code to make the macro work more efficiently. Thank you in advance for your help.

Please find the code here:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I have added the code tags to my original post, my apologies, this was my first post to this forum.

Thanks for taking the time to read and comply with the rule .

Why do you loop through the worksheets twice?

You don't need to select, this will slow the code

Just copy the sheets to a new workbook

Try this

Please Login or Register  to view this content.

Kaplan275,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.