Incorporating Matrix Functions From Excel

[LHenkel]

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

 

[Tom Ogilvy]

Application.Minverse