Re: Copy ranges one workbook to another
I speak too soon. It works ... but only under certain circumstances.
If I run the macro from the sheet I am pasting to (ws2), it works
If I try and run it from any other sheet in the macro, or if I try and run it from ws1 (the other workbook), I get a run time error "method of Range class failed", and the debugger highlights the Range.Select code (the second of the three lines above)