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

Application.Minverse

--
Regards,
Tom Ogilvy

"LHenkel" <lhenkel@ne.rr.com> wrote in message
news:1113866656.882439.235600@l41g2000cwc.googlegroups.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
>