Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum with matrix functions? | Excel Worksheet Functions | |||
Using Matrix functions on complex numbers | Excel Worksheet Functions | |||
IF and VLOOKUP functions for a matrix overview | Excel Worksheet Functions | |||
Incorporating Excel Spreadsheet into Word? | Excel Discussion (Misc queries) | |||
Matrix Functions | Excel Programming |