Hi y'all,
I have a medium sized array and want to sort it on more than one element in the 2nd dimension.
Dim slA(500,9) As String
For example on "Columns" 0 then 1 then 6 then 4 of the (9) Dimension... Hope that makes sense. :-)
Can anyone tell me for *definate* wether sorting in a complex way of... (briefly) ...
Extracting a seperate array of the same elements from 1
Sorting on 0
Extracting a seperate array of the same elements from 0
Sorting on 6
... etc
... is the same as
Concatonating all of the fields in the required order
Sorting
I know I could dump to a sheet and use Excels sort but I want to use the code in Access and Word as well... hence the array.
I really can't seem to get my head around it!! :-(
TIA
Lisa
Wishing you all a great 2012!!
Lisa
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
----------------------------------
Tidak ada komentar:
Posting Komentar