Daniel -
Browse to
www.microsoft.com, click Support, and search for "excel minverse,"
and you'll see
http://office.microsoft.com/en-us/ex...091791033.aspx
where it says, among other things, "The size of the array must not exceed 52
columns by 52 rows. If it does, the function returns a #VALUE! error."
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
"Daniel" wrote in message
...
Can someone tell why this routine does not work for an array larger than
50?
thanks
Sub inve()
Dim Arr1(1 To 255, 1 To 255) As Double
Dim Arr2 As Variant
Dim R As Long
Dim C As Long
'values
For i = 1 To 250
For j = 1 To 250
Arr1(i, j) = Sheets("abc").Cells(i, j)
Next j
Next i
Arr2 = Application.WorksheetFunction.MInverse(Arr1)
'End Sub