Copying Multiple Ranges to another workbook not working

[Excel987]

Hi All!
I created a VBA macro to copy data from specific worksheets in a workbook to another workbook with the same worksheet names. The code is looping through the worksheet correctly, but the code I have to copy specific ranges from the source workbook and then paste it to the target workbook is not working. The code will copy a single cell over in the loop, but not a range of cells. Below is my code.

I thank you in advance for your assistance.

- Ron -

Please Login or Register  to view this content.

[AlphaFrog]

When you open the Source workbook, it becomes the active workbook. You then set your target to the active workbook. So then the source and target are the same workbook.

Solution: set the target to the active workbook before opening the source workbook.

[fredlo2010]

When you open the Source workbook, it becomes the active workbook. You then set your target to the active workbook. So then the source and target are the same workbook.

Like Alphadog said you just have to swap these lines

Please Login or Register  to view this content.

Thanks

[AlphaFrog]

You have to swap these lines

Please Login or Register  to view this content.

[Excel987]

Hi AlphaFrog!
First, I want to thank you for taking the time to look at my code.

I switched the lines to set the target to the active workbook before opening the source workbook. See the code below. But it is still not copying over the data from the source workbook to the target workbook. Thanks again for your help.

Please Login or Register  to view this content.

- Ron -

[fredlo2010]

try adding ".value" at the end of each range

so this line:

Please Login or Register  to view this content.

becomes:

Please Login or Register  to view this content.

Thanks

[AlphaFrog]

Is Finance13new.xlsm the active workbook when you start the macro?

[Excel987]

Hi Fredlo2010!
It worked!

Thank you so much for your and AlphaFrog assistance. It is very much appreciated.

- Ron -

[Excel987]

Hi AlphaFrog!
I added .value at the end as fredlo2010 suggested and it worked.

Thank you for your help, which started the ball rolling with fixing my code. I very much appreciated your help in this matter.

- Ron -