Copy and Paste ranges between files
Thanks for the tip.
Will try this out soon
Ta!
R
"Tom Ogilvy" wrote in message
...
With workbooks("File A.xls").worksheet("sheet1")
.range(.cells(1,1), .cells(1,11)).copy _
Workbooks("File B.xls").worksheets("Sheet2").Range("A1")
End With
Regards,
Tom Ogilvy
"dude" wrote in message
...
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
|