Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a variable number of 3x3 matrices in a 3-D array. I have dimensioned as follows: ReDim MatrixA_3x3(1 To lngLastRow - 2, 1 To 3, 1 To 3) The entire array is populated correctly, as the elements are as I expect -- MatrixA_3x3(i, j, k) is accurate. How can I reference the individual 3x3 matrices so that I can calculate the determinant of each one? I have the following: arrA_Determ(i) = Excel.Application.MDeterm(MatrixA_3x3(i)) The code is bombing with a "subscript out of range error." on the MatrixA_3x3(i) part. Is it possible to reference the entire array based on the first dimension, or do I need to junk this approach? (Not a problem to do so, if necessary) The obvious choice would be to use a 2-D array, but I would like to see the underlying matrices. Thanks, Jay Petrulis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Application.match against one dimension of a multidimensional array? | Excel Programming | |||
Multidimensional Array | Excel Programming | |||
MAX of Multidimensional Array | Excel Programming | |||
Multidimensional Array problem I can't solve ! Please help me out ! | Excel Programming | |||
size of multidimensional dynamic array | Excel Programming |