Ordering an array

  • Thread starter Thread starter il barbi
  • Start date Start date
I

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
Scanning records of form+subform 1
Sorting an array or listbox 3
Excel VBA help: Text file formatting 19
Test if an array is filled 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
transferring arrays between subroutines 1
Best ways to search an array/collection for an element 8

Back
Top