Just out of educational curiosity... On an array with 1,000 numbers, I
found that using Max was a little faster than Large by about 20-30% .

--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Brad Patterson" wrote in message
...
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.)