Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generalising sort routine
Hi,
I wrote a routine to sort 2-dimensional integer arrays, but I would like to extend it to sort any data. If I would use another programming language I would add the "Compare" function and "Exchange" routine as parameters, so the interface would be someting like: Sub Sort( ObjectsToSort() , LowBound, HighBound, CompareFunc, ExchangeSub). Unfortunately passing functions/subs as parameters does not seem to be possible in VBA. Anyone has an idea how to accomplish this? I was thinking of creating classes with each their own Sort method, but have no idea how to do this in VBA. Any info on the net about how to create classes/objects in VBA? Greetz, Lex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Routine | Excel Discussion (Misc queries) | |||
sort and tally routine | Excel Programming | |||
Generalising Deleting Rows after AUTOFILTER | Excel Programming | |||
Sort Routine VBA | Excel Programming | |||
Need a Special Sort Routine | Excel Programming |