Excel Programming Help -- Hi.  I'd like to know how to use an array
function such as mmult or minverse inside of an Excel VBA 2000
program.

Thanks,

Lisa

Hi Lisa,

think you might find this useful...

http://econ.ucsd.edu/~kantonov/e172cs01/mmult.htm
http://www.duncanwil.co.uk/simult.html
http://www.mrexcel.com/archive/Errors/8883.html
--------------------------------------------------------------------


**Taken from: http://econ.ucsd.edu/~kantonov/e172cs01/mmult.htm

How to Multiply Matrices In Excel:

Type in original matrix or matrices.  Each cell should correspond to
an element of the matrix. Select a set of empty cells corresponding to
the size of the matrix that will contain the result.

From the ?Insert? menu select ?Function?.  Select ?Math & Trig? and
then the ?MMULT? function and click ?OK?. For ?Array 1? and ?Array 2?,
select the matrices that you wish to multiply and then click ?OK?.

Go to the formula bar and select its contents.  Type
?CTRL-SHIFT-ENTER? at the same time.  You?re done.
 

How to Invert a Matrix in Excel:

Type in the matrix you wish to invert.  Each cell should correspond to
an element of the matrix. Select a set of empty cells corresponding to
the size of the inverted matrix.

From the ?Insert? menu select ?Function?.  Select ?Math & Trig? and
then the ?MINVERSE? function and click ?OK?. For ?Array?, select the
matrix that you wish to invert and then click ?OK?.

Go to the formula bar and select its contents.  Type
?CTRL-SHIFT-ENTER? at the same time.  You?re done.

Hi Lisa,

Are you looking for information about how to use arrays in VB or how
to reference a matrix function in VB or general information about
matrix functions?

In Excel VB you can specify a range of cells as a parameter of a function such as:
   answerArray = Excel.WorksheetFunction.MMult(A2:B3,A5:B6)

You can also create actual arrays:
   Dim myArray1(2, 2) As Integer
   myArray1(0, 0) = 1
   myArray1(0, 1) = 3
   myArray1(1, 0) = 2
   myArray1(1, 1) = 7

   Dim myArray2(2, 2) As Integer
   myArray2(0, 0) = 3
   myArray2(0, 1) = 5
   myArray2(1, 0) = 2
   myArray2(1, 1) = 4

   answerArray = Excel.WorksheetFunction.MMult(myArray1, myArray2)

-- Carl