I have an upcoming project requiring that VBA objects be sorted.

I know that I can write the objects out to a Worksheet and then sort
the objects and re-read them.

But I'd prefer to keep everything in memory.

... Um I've googled and discovered functions for Quicksort and
Bubblesort.

I could use those. But,

Does Excel provide any support for sorting objects.

Like Java does with the Comparable class or like C does with Quicksort
and a pointer to a function.

.....

To give you an idea of what I'm working on, objects are first sorted
on a double, then the objects
are broken into a partition and sorted within the partition, then the
partitions are sorted, and then
partitions of the partitions are sorted.

Thanks.

Try something like this:

http://www.vbrad.com/pf.asp?p=source...collection.htm

Or create a disconnected ADO recordset, populate its columns with your
object properties and then sort that.


Tim.


wrote in message
ups.com...
I have an upcoming project requiring that VBA objects be sorted.

I know that I can write the objects out to a Worksheet and then sort
the objects and re-read them.

But I'd prefer to keep everything in memory.

.. Um I've googled and discovered functions for Quicksort and
Bubblesort.

I could use those. But,

Does Excel provide any support for sorting objects.

Like Java does with the Comparable class or like C does with Quicksort
and a pointer to a function.

....

To give you an idea of what I'm working on, objects are first sorted
on a double, then the objects
are broken into a partition and sorted within the partition, then the
partitions are sorted, and then
partitions of the partitions are sorted.

Thanks.