Incorporating Matrix Functions From Excel
 

Excel has some matrix functions such as transpose, mmult, and minverse.

Suppose you want to use one of these functions and put the result in
cells in a worksheet, but you want to use VBA because variuos things
such as the size of your matrix may vary.

So for instance, suppose you have a nxn matrix, and you want to compute
minverse of the matrix from within a VBA program, or using cells
assigned by the VBA program -- how do you do it?

Thanks

Incorporating Matrix Functions From Excel
 

Application.Minverse

--
Regards,
Tom Ogilvy

"LHenkel" wrote in message
oups.com...
Excel has some matrix functions such as transpose, mmult, and minverse.

Suppose you want to use one of these functions and put the result in
cells in a worksheet, but you want to use VBA because variuos things
such as the size of your matrix may vary.

So for instance, suppose you have a nxn matrix, and you want to compute
minverse of the matrix from within a VBA program, or using cells
assigned by the VBA program -- how do you do it?

Thanks