Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum with matrix functions? Aale de Winkel Excel Worksheet Functions 8 September 18th 09 01:35 PM
Using Matrix functions on complex numbers Greg Conway Excel Worksheet Functions 0 April 20th 08 11:11 AM
IF and VLOOKUP functions for a matrix overview Marc Bucher Excel Worksheet Functions 4 November 2nd 07 07:50 AM
Incorporating Excel Spreadsheet into Word? Pookie76 Excel Discussion (Misc queries) 1 March 30th 06 08:36 PM
Matrix Functions Martin Mrazek Excel Programming 1 March 5th 04 09:33 PM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"