I want to calculate matrix determinants (using the function "
MDETERM"), the size of which are contingent on the value AL33 in the example below. I can use either the Excel 2010 row number/column number method for "address" or the "cell(address..." technique (as I've done below) to get the references I would like to put into the array for the
MDETERM function, but apparently the references are only seen as text, and when I try as a formula:
I get the message "
the formula you typed has an error"
I use 2010, and have tried different methods with the EVAL (both with and without VBA) function in an attempt to make the address result "readable", but to no avail.