The use of multiple sort keys in a sort will depend entirely on the code you
are using. Could you post it please?
Regards, Dave S
----- Original Message -----
From: "lisafaygreen" <1z@compuserve.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Friday, January 06, 2012 4:32 AM
Subject: [ExcelVBA] Sorting in VBA
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1416 / Virus Database: 2109/4124 - Release Date: 01/05/12
>
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