View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LHenkel LHenkel is offline
external usenet poster
 
Posts: 1
Default 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