Windows XP Mdeterm(A) in Macro does not work?

P

pauler

Joined
Feb 1, 2010
Messages
2
Reaction score
0
Mdeterm(A) in the following Macro will not function, any suggestions?

Sub testcall()
Dim A(2, 2)
[a12].Select
For i = 1 To 2 Step 1
For j = 1 To 2 Step 1
A(i, j) = i + j
Next
Next
md = Application.WorksheetFunction.MDeterm(A)
ActiveCell.Offset(i - 1, 4).Value = md
End Sub
 
Folks, the answer is Dim A(1 to 2, 1 to 2) and it works. Found this on another blog after searching on google for: Application.WorksheetFunction.MDeterm(A)
Thx for allowing me a chance to ask the correct question.

Pauler
 
Back
Top