Ordering an array

[il barbi]

Is there some VBA function to sort an array of long
integers, say some library function? I already wrote a full
VBA coded subroutine but I think some built-in function
would be faster
il barbi

 

[SFAxess]

Here are some sorting algorithms by MS
http://www.microsoft.com/officedev/articles/movs102.htm
There is no built in function for sorting an array.

 

[Adrian Jansen]

You have got the Jet engine - a pretty good sorter. Write the array to a
table, then query the table with the sort order you want.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control