Add to 2 dimensional array without losing data.

[atf32]

How can I add ROWs to an array that already has data? I have an array that holds two columns of data. Later in my code, I want to be able to append to the array and add more data, without losing any data that is already in the array.

 

[mikerickson]

Perhaps something like

Dim myArray as Variant
Dim tempArr as Variant

ReDim myArray(1 to 10, 1 to 2)]
Rem fill myArray

tempArr = Application.Transpose(tempArr)

ReDim Preserve tempArr(1 to 2, 1 to 20)

myArray = Application.Transpose(tempArr)

 

[atf32]

Thanks......However, it only worked when I replaced your line:

tempArr = Application.Transpose(tempArr)

WITH

tempArr = Application.Transpose(myArray)

Regardless....thank you!!!!