ChloeRadshaw
12-15-2008, 05:33 PM
Guys,
I am completely lost here and spent the whole day banging my head against the wall:
Dim matrixA(0 to 0, 0 to 4) As Variant
'Populate matrix A
Dim matrixB(0 to 4, 0 to 0) As Variant
Populate matrix B
Dim z() As Variant
z = Application.worksheetfunction.mmult(matrixA, matrixB)
This does not work and returns an error saying cannot get the mmult function .....
I am really lost
Does anyone have any ideas / examples about how this works and what needs to happen?
The exact error messgae I got was
"Unable to get the MMult property of the WorksheetFunction class"
I am completely lost here and spent the whole day banging my head against the wall:
Dim matrixA(0 to 0, 0 to 4) As Variant
'Populate matrix A
Dim matrixB(0 to 4, 0 to 0) As Variant
Populate matrix B
Dim z() As Variant
z = Application.worksheetfunction.mmult(matrixA, matrixB)
This does not work and returns an error saying cannot get the mmult function .....
I am really lost
Does anyone have any ideas / examples about how this works and what needs to happen?
The exact error messgae I got was
"Unable to get the MMult property of the WorksheetFunction class"