Can you identify the maximum value in an array?
Dim Arr(5) as integer
Arr(2) = 99
Arr(3) = 101
How do I then find out what the maximum value is, and what position itıs at
in this type of array * i.e. for the above, the maximum is 101, at position
3.
Iıve had success with
Application.WorksheetFunction.Large(Arr, 1)
But still canıt get the position of that number.
Iım attempting this with an array that is 1000 in size if thatıs going to
be a problem ...
Thanks,
Brad.)
|