________________________________
From: paulschreinerindy <schreiner_paul@att.net>
To: ExcelVBA@yahoogroups.com
Sent: Friday, January 6, 2012 8:29:08 AM
Subject: [ExcelVBA] Re: Sorting in VBA
Lisa,
Can you post some sample data? just a few records.
Both Unsorted and Sorted?
I think I'd be better off trying to look at it "fresh" rather
than trying to work through code that ISN'T working and try to
figure out what it was INTENDED to do that it's not...
does that make sense?
Paul S
--- In ExcelVBA@yahoogroups.com, "lisafaygreen" <1z@...> wrote:
>
> 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
>
[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
----------------------------------
Tidak ada komentar:
Posting Komentar