Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting contents in aray | Excel Discussion (Misc queries) | |||
VLOOKUP Question - Can I Keep the Same Aray with Drag? | Excel Worksheet Functions | |||
Passing a string aray as an argument to a function ?....Help! | Excel Programming | |||
Looping and Filling Info | Excel Programming | |||
Named Aray Formula | Excel Programming |