sort numeric array

[Guest]

hi! I have an array with numbers. i want to sort the array based on the size
of the numers. how can i do this? do I need to write a function for it or
does it exist in vba already? please help!

 

[NickHK]

Arne,
One of these methods in VBA, depending on the number of elements:
http://www.google.co.uk/search?hl=en&q=vb+array+sort&btnG=Search&meta=

Or get Excel to do the sort for you:
Dump the array on a WS, out of the way
Sort on the WS
Pick up the sorted values.

NickHK

 

[Gary Keramidas]

here's an example, don't remember who posted it, though:

Sub sort_array()
Dim arr As Variant
Dim i As Long, j As Long, temp As Long
'sort the array
arr = Array(2, 3, 4, 1, 6, 8, 7)
For i = LBound(arr) To UBound(arr) - 1
For j = i + 1 To UBound(arr)
If arr(i) > arr(j) Then
temp = arr(j)
arr(j) = arr(i)
arr(i) = temp
End If
Next j
Next i
MsgBox arr(0)
End Sub