lisa's file here:
http://f1.grp.yahoofs.com/v1/AGwIT0wrvlfQPZ3GcT7_CaHZy2hp3Lu2YeJKZqiNYj5ibPVea2Fd51WHsLVZsOIcsOC2lfDUYWDTAozkTjuF5g/Files%20Needing%20Help/Sort%20in%20VBA%20Problem.xlsm
or if that link fails try:
http://tech.groups.yahoo.com/group/ExcelVBA/files/Files%20Needing%20Help/Sort%20in%20VBA%20Problem.xlsm
--- In ExcelVBA@yahoogroups.com, weishi zhu <weishizhu@...> wrote:
________________________________
> From: paulschreinerindy <schreiner_paul@...>
> 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