Ron Rosenfeld formulated on Friday :
On Fri, 23 Nov 2012 13:07:33 -0500, GS wrote:

I'm going to say that I've done exhaustive tests with various sorting
solutions and found none faster than dumping the list into a temp wks
and using Excel's Sort function followed by dumping the result back
into an array for processing, or into a ListBox if appropriate.

I agree. And for multicolumn sorts, that is my preference. But for single
or two column sorts, the coding seems simpler (for me) to just do it in VBA.

I agree.., as long as the lists are relatively short. I typically store
lists on a hidden sheet that has named ranges for each list. I usually
leave them sorted after adding/removing items so they're 'ready-to-use'
however I need/want. Different case, though, for working with list
items on the fly.<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion