Matrix operations

[hbukac]

I have a VBA code that does (in the loop) matrix addition, matrix multiplication, matrix inversion and the matrix eigenvalue problem. All matrices change in every step.
I do these operations in the Excel spreadsheet. This requires matrices to be written in and read repeatably. Even if I use two dimensional array as a range object, the calculation is very slow. Is there any way how to do matrix opertations in VBA without writing and reding them in and from the spreadsheet?

 

[zacemmel]

I haven't written any matrix code, but just by thinking about it, I don't know why it would be slow unless your matrices are extremely huge.

Can we see some sample code?

Oh, and FYI, MMULT is a built-in matrix function, check it out.
This message was edited by zacemmel on 2002-10-26 15:39