Paul,
Sure... Makes a *lot* of sense.
"Fresh" is Good.
I've "started anew" a number of times now and am still not sure about the sort creating the the same as Excel.
I'm going to ask for a workbook to be posted. not going to do it myself because that may be seen as taking advanage of being a moderator... :-).
The data is over 300 lines.. It's a dump of the array I want to sort on "columns" / elements 1 then 0 then 6 then 4.
As extra information those are.. Project, Called Procedure, Calling Module,Calling Procedure respectively... by which you may have guessed it's to do with the VBE. I'm trying to populate a treeview with Called procedures, number of times called and where they are called from.
The sheet SORT has all of the data in ... Raw format, Excel Sorted format, Space for Proc sorted format - which is currently a copy of the excel sorted data, and lastly a space for results which is just =If(Exec Sorted<>Proc Sorted,"No","")
I've included a proc to dump the arrays to a sheet and the "ordinary" sort proc I use.
And Thanks
Lisa
Subject: [ExcelVBA] Re: Sorting in VBA
Lisa,
an you post some sample data? just a few records.
oth Unsorted and Sorted?
I think I'd be better off trying to look at it "fresh" rather
han trying to work through code that ISN'T working and try to
igure out what it was INTENDED to do that it's not...
does that make sense?
Paul S
[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