Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get the MINVERSE of Worksheet Function Class ?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to get the dropdowns property of the worksheet class??? | Excel Programming | |||
Run-Time error '1004: Unable to get the PivotTables property of the worksheet class | Excel Programming | |||
Run time error 1004 - unable to get the chartObjects property of the worksheet class | Excel Programming | |||
Error: Unable to get the OLEObjects property of the worksheet class | Excel Programming | |||
Run-time error '1004' - Unable to set the Visible property of the Worksheet class | Excel Programming |