Copy and Paste ranges between files

[dude]

How do you copy cells from 1 workbook (File A) worksheet (sheet1) to another
workbook(File B) worksheet(sheet2)?

I have sucessfully written a working but not so elegant solution via
activating workbooks.

I am trying to write this without activating files in a loop as it is a less
efficient way of running things.

I am having difficulty wrapping my head around referecing ranges and
worksheets across multiple forms (with out activating).

workbooks("File A").worksheet("sheet1").range(cells(1,1), cells(1,11)).copy

vba returns so sort of application error.

Thanks in advance

R

 

[dude]

Thanks for the tip.

Will try this out soon

Ta!

R

 

[dude]

Thanks Tom,

Finally understand how ranges/worksheets/workbooks work ... ta!