View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_56_] Andrew[_56_] is offline
external usenet poster
 
Posts: 130
Default Using matrices is vba code

Hello,
I am trying to do some simple matrix manipulation in vba. Here's what
I have:

A = 4x4 matrix, B = a 4x1 column, and C= a 4x1 column. declared as
Dim A(1 To 4, 1 To 4) As Double
Dim B(1 To 4) As Double
Dim C(1 To 4) As Double

What I want to do is invert A, then multiply it by B, and put the
results in C.

Functionally, my code is doing this... C = (A^1)*B
Of course vba doesn't understand what I want it to do. I have tried
to implement the code as

C=MInverse(A) - code won't get past here.
C=MMult(C,B)

Can someone send me an example of how to implement C = (A^1)*B

thanks,
Andy