sorting an array

[Fire_Chief]

I have an array I call NUMBERS (X)

I have dim it NUMBERS(100)

After I get all the values in it, which might be as many as 80, I want to find out what the highest number is.

How do I sort them to find this?

Thank You

Marty

 

[Norie]

Marty

Why not just use Application.Max(NUMBERS)?

 

[Fire_Chief]

How do i use it ?

 

[erik.van.geit]

Hi,

try this

Sub test()
Dim NUMBERS As Variant

NUMBERS = Array(1, 6, 8, 12, 5, 123, 3)
MsgBox Application.Max(NUMBERS)
End Sub

kind regards,
Erik

 

[Fire_Chief]

Here is the array I have

One of thiese has the highest numer. How do I find it?

For I = 1 to 10

HighNumber(I)

next I


Marty

 

[Fire_Chief]

I will also have to find the second higest number.

 

[erik.van.geit]

Here is the array I have

One of thiese has the highest numer. How do I find it?

For I = 1 to 10

HighNumber(I)

next I


Marty

what did you do with the provided examples ?
how did you try to combine them with the example you are giving ?

 

[Fire_Chief]

They are not combined.
But
I found a way to do it

Thank you for your help