VBA to copy from one sheet to another

Hi.

I am trying to piece a macro together from 2 different macros and only half of it is working.

The first half works, but when it gets to the part where I want it to copy from the "Preferences" sheet, it doesn't do anything.

What do I need to change to get that part to work?

Please Login or Register  to view this content.

I suspect that you have those lines the wrong way round, this

Please Login or Register  to view this content.

is copying from the active workbook to the workbook the code opened, should it be

Please Login or Register  to view this content.

Originally Posted by Fluff13

I suspect that you have those lines the wrong way round, this

Please Login or Register  to view this content.

is copying from the active workbook to the workbook the code opened, should it be

Please Login or Register  to view this content.

LOL! I feel stupid. Yes, that worked. Thanks for your help

You're welcome & thanks for the feedback.