Hi guys,
I've been trying to copy values from one range to another, and the ranges need to be dynamic. Normally I use a combination of the 'range' and 'cells' properties, like this:
or something similar, and it works fine.Please Login or Register to view this content.
However, when I try to do this across two workbooks I get a runtime error. I've isolated the piece of code causing the problem as here:
The thing that confuses me is that if I change the range references to a1 style then it works fine:Please Login or Register to view this content.
Anyone have any ideas why the second sub works but the first doesn't?Please Login or Register to view this content.
Thanks, Sam.
p.s. I realise I could use copy and paste for this, was just wondering why this method didn't work in this instance.
Bookmarks