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
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