Ok

When I use option base 1, then it works for me.

I tested with the following

Sub eee()

Dim arr2(4, 9)
arr = Array(39.7223, 49.2126, 28.002, 27.943)
For i = 1 To 4
arr2(i, 9) = arr(i)
Next i

MsgBox WorksheetFunction.Max(WorksheetFunction.Index(arr2 , 0, 9))

End Sub

----- ExcelMonkey wrote: -----

But I used Option Base 1 before my variable declarations.


---
Message posted from http://www.ExcelForum.com/