Problem:
Question- How to use MDETERM function in VBA
I would like to use the MDETERM sprreadsheet function in VBA without starting with a spreadsheet range.
I have set it up like this iinside a VBA function
Dim A()
ReDim A(2,2)
dim d as Variant
.
.
.
'Here I used some statemeents to explicitly define the contents of A
'Now, I call the MDETERM functtion
d = Application.WorksheetFunction.MDeterm(A()))
The function call fails, presumably because I am not sending it a spreadsheet range in the form A1:B2 or something like that.
Is there anny way to call the function using the array I have defined above?
PLease describe in detail.