Sorting arrays - Excel97 VBA
Hi David,
For a large array of random values, the quickest sorting method is generally
considered to be the Quicksort.
A web search is bound to turn up a bunch of sites with the quicksort
algorithm, and probably some with VBA code you can adapt.
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
Word FAQs at http://www.multilinker.com/wordfaq
Please post any follow-up in the newsgroup. I do not reply to Word questions
by email
Quote:
>I saw a post on this subject recently - but did not see any reply.
>I need to sort large 2 dimensional arrays, and although I do have a "brute
>force" routine it is only usable for fairly small arrays - it becomes
>impossibly slow for the 6000+ size I need to sort.
>Can any one help?
>Apologies in advance for not thanking any helpful respondents - Outlook
>Express has taken to crashing whenever I try to reply to a posting!
>David Trickett
