Lisa,
The current data is over 300 lines...
In the future, how much data are we talking about?
Could it conceivable exceed 1000? 10,000?
Only curious because it may change what approach I'd take.
as for "taking advantage of being a moderator":
I'm sure the Company Car, the Condo on the Beach (with free maid service and
stocked mini-bar) and the use of the company jet for vacations are sufficient
perks for your job as moderator... posting your own attachments would be WAY
over the top! (lol)
Unless the other moderators would be jealous that you're actually getting some
WORK done!
Then, I suppose the slight delay in rendering assistance can be tolerated... ;)
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: "1z@compuserve.com" <1z@compuserve.com>
To: ExcelVBA@yahoogroups.com
Sent: Fri, January 6, 2012 12:44:52 PM
Subject: Re: [ExcelVBA] Re: Sorting in VBA
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]
[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