Copy and Paste problem with VBA macro

[bcselect]

Have workbook A and workbook B. Each one has 12 worksheets, and are named and structured identically. Need to copy from A and paste to B. Current code opens A, selects sheet 1, selects a range, and copies. Then opens B, selects sheet 1, selects range, and pastes. Next, opens A, selects sheet 2, selects a range, and copies. This continues until all 12 worksheets have been processed.. Considering memory usage and speed, is there a more economical (better) way to do this?

 

[Fluff]

It may well be possible to improve your code, but you will need to post it. How to Post Your VBA Code