Copy data from workbooks
Hi All,
Can someone tell me if the following code is possible:- I get an "Object
does not support this property or method"
Can use arrays in this fashion - Set sourceRNG = myBook.rngSource(i).
I am trying to Open a workbook and copy an array of source ranges to an
array of destination ranges.
Here is an extract from my code:-
Set rngSource(1) = Worksheets("Sheet 1").Range("A8:U79")
Set rngSource(2) = Worksheets("Sheet 2").Range("A7:X10")
Workbooks.Open (SRCbook)
Set myBook = ActiveWorkbook
For i = 1 To UBound(rngSource)
Set sourceRNG = myBook.rngSource(i)
|