$$Excel-Macros$$ Re: MDETERM function

2008-09-29 Thread rcl2884
If I understand the question right, this is easy... Define a matrix as an array of doubles for example Dim M(2,2) as double This will be a 3X3 matrix. You can fill in the values any way you want. The determinant of this matrix is found by calling x = application.MDETERM(m) On Sep 29, 6:2

$$Excel-Macros$$ Re: MDETERM function

2008-09-30 Thread rcl2884
I was suggesting taking advantage of the Excel function MDETERM rather than writing your own. You can simply call the Excel function within VBA by using "application.MDETERM". There is no doubt a clever way to write your own procedure to do the determinent of a general nxn matrix, but I have not