View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gimme_this_gimme_that@yahoo.com is offline
external usenet poster
 
Posts: 129
Default Built In Support for Sorting Objects

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.