Sorting an Array

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
there's no build-in function. One workaround:
- place your data in a worksheet range
- sort the range usings Excel' sort features
- read the data into your array
 
The code at tinyurl looks good, but it is all from 1998. Have there not been
any code improvements to VBA since 1998 that might improve performance?
 
Hi
not really :-)
The code should work without any issues in the newer Excel versions :-)
 
There have been functions added to VBA since 1998 (Join, Split, Replace come
to mind), but sorting isn't one of them.
 
You must log in or register to reply here.

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

Array Declaration. 1
Sorting within an array 1
Excel 2003 - define name like a filtered list 1
Shape Arrays VBA 0
How do I average time (hh:mm:ss) excluding zeros? 2
get #N/A from vlookup function 4
Sorting Cells that contain an Array as Dates 1
sort X-Y co-ordinates 2

Back
Top