Avoid using .activate during loop

[Rhapsodie]

I have two workbooks open. Each has a group of numeric named ranges, e.g. "Draw1","Draw2","Result1","Result2",etc.

I need to loop and copy parts of the named range in one workbook to parts of the named range in the other workbook, e.g.

Please Login or Register  to view this content.

This works but the jumping between workbooks is a pain. I haven't worked out yet how to do this without using activate.

[Bob Phillips]

Not tested, but this looks rigt to me

Please Login or Register  to view this content.