filling an aray without looping
 

Is it possible to simply fill it by using an array formula without
looping
to fill it in the same way as you can fill a range with an array such
as:

Range("C1:E20).FormulaArray =
Application.WorksheetFunction.MMult(InvVCVRange, AlphaRange)


By (after rediming it) saying: Array (3,20) =
Application.WorksheetFunction.MMult(Range1, Range2)

Thks, Mark

filling an aray without looping
 

You can assign the result of MMult to a variant:

Dim vArray As Variant
Dim i As Long
Dim j As Long

vArray = Application.MMult(Range("A1:A10"), Range("B1:K1"))

For i = 1 To UBound(vArray, 1)
For j = 1 To UBound(vArray, 2)
Debug.Print "vArray(" & i & "," & j & "): " & vArray(i, j)
Next j
Next i



In article .com,
wrote:

Is it possible to simply fill it by using an array formula without
looping
to fill it in the same way as you can fill a range with an array such
as:

Range("C1:E20).FormulaArray =
Application.WorksheetFunction.MMult(InvVCVRange, AlphaRange)


By (after rediming it) saying: Array (3,20) =
Application.WorksheetFunction.MMult(Range1, Range2)

Thks, Mark