Copy array to another workbook

[flynavy]

I have some complicated VBA code to populate a 2-D array (250 by 366). When the array has been populated, I want to copy the array to another workbook. I believe there is a way to efficiently copy en masse with very simple code. Any thoughts?

 

[igold]

Hi flynavy,

You have not given us a whole lot to work with, but how about after the array is populated you use Resize on the upper left destination cell and make it equal to the array.

Generically, something like this...

If you have a 2 dimensional array, you need to use Resize to resize the destination range to the proper size. The first dimension is the number of rows and the second dimension is the number of columns. The code below illustrates writing an array Arr out to the worksheet starting at cell A1.

Dim Destination As Range
Set Destination = Range("A1")

Destination.Resize(UBound(Arr, 1), UBound(Arr, 2)).Value = Arr

HTH

igold