VBA: How to merge six seperate 10x1 arrays into one 10x6 array?

[MikeCas]

I'm working on a linear regression sub that creates a model equation to predict data points and I've reached a standstill in my project as I cant seem to find a pathway to merging the six 10x1 arrays into a single 10x6 array in order to perform a series of matrix manipulations using the 10x6 array. Each column of the 10x6 array needs to be composed entirely of the elements from the same 10x1 array. Any help pointing me in the right direction would be greatly appreciated.

 

[Kamolga]

Hi,

There might be an easy way to union them but the method out of my head would be

Dim MyArray(10, 6) As Variant
    Dim r As Long [COLOR=#008000]'row[/COLOR]
    Dim c As Long [COLOR=#008000]'column[/COLOR]
        For r = 1 To 10
            For c = 1 To 6
             [COLOR=#008000]  'Assign Array to Column[/COLOR]
                   If c = 1 Then
                       MyArray(r, c) = [COLOR=#0000ff]Array1[/COLOR](r)
                   End If
                  if c=2 then
                     MyArray(r, c) = [COLOR=#0000ff]Array2[/COLOR](r)
                   End If
[COLOR=#008000]                   'and so on[/COLOR]
          Next c
      Next r

 

[Kamolga]

Redim MyArray (1 to 10, 1 to 6) as variant

if error