Hi i need a code in VBA Module that calculates the determina

Hi i need a code in VBA Module that calculates the determinate of the matrix given( -1,4,2,7;0,3,5,-3;0,0,2,6;0,0,0,8)

My prof told me you can calculate this via VBA by using 2 or 3 lines of codes in Module. Thanks!

Solution

The given matrix is already in the form of row echelon form,

From this we can easily find out the solution.

The multiplication of diagonal elements is determinant of matrix.

= -1 * 3 * 2 * 8

= -48