Steve
From my point of view, you are on target.
Perhaps the thing missing in the concatenated key discussion is that you
need to move the whole rows during an interchange. This is frequently no
in most example-sort routines.
If moving the data around is what you are trying to avoid then you can
create and access the array via an indexList()
[array(indexlist(m),column)], and only interchange indexlist entries;
returning the indexlist() to the user for all subsequent accesses to the
sorted array. A benefit of this is that you don't lose the original order
of the array.
Db
[Non-text portions of this message have been removed]
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar