You could try loading the data into an ADO recordset and using the
recordset's sort method.

could expand/modify this (see second example):
http://groups.google.com/groups?hl=e...%40cppssbbsa05


Tim.


"Marston" wrote in message
om...
Hi -

I've gone through many of the old posts on quick sorting and haven't
quite come across what I think would solve my problem.

I have a very large array that has been loaded from multiple
worksheets.
In general, its somewhere in the neighborhood of 100,000 rows x 10
columns.

What I'd like to do is sort all the information based first on the
values in each of the rows and one of the columns and then within
that
set, sorting on a second column, and so on until the entire array
has
been sorted by each of the columns.

What I've seen will sort on any one column within a 2-d array, but
not
multiple columns.

Thanks in advance