Arne,
One of these methods in VBA, depending on the number of elements:
http://www.google.co.uk/search?hl=en...G=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

"Arne Hegefors" wrote in message
...
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!