View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Patterson Brad Patterson is offline
external usenet poster
 
Posts: 16
Default 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.)