Unable to get the MINVERSE of Worksheet Function Class ?

D

Daniel

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
 
D

Daniel

Mike,
It was good to be true... I guess the same with MMULT
why MS does it that way, is there a hard limitation?
we are not talking about memory here
thanks anyway
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top