Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.WorksheetFunction.MMult
Hi,
I just want to write a quick function in VBA which performs the the matrix multiplication of a vector with itself transposed. In a worksheet the calcul would look like this {=MMULT(myVector,TRANSPOSE(myVector))}. If myVector is for instance 7;8;9 then the result would simply be 49. However, when I call the Test vba Function it just doesn't work: Function Test(myVector) As Double Test = Application.WorksheetFunction.MMult(MyVector, _ Application.WorksheetFunction.Transpose(MyVector)) End Function Am I missing somethin here? Thank you in advance Gabriel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reuse Application.WorksheetFunction | Excel Discussion (Misc queries) | |||
Application.WorksheetFunction error | Excel Discussion (Misc queries) | |||
Need help with Application.WorksheetFunction | Excel Discussion (Misc queries) | |||
application.worksheetfunction.mmult help | Excel Programming | |||
Using Application.WorksheetFunction.Ln(...) in VBA | Excel Programming |