Michael,
Glad you got it "sorted" out .. :-)
Lisa
Sent: Mon, Jan 14, 2013 3:25 am
Subject: [ExcelVBA] Re: Puzzling Behavior
I assemble data for each style from several spreadsheets, and combine them to
create one "master" row for a style. So I have 2000 rows for 2000 styles. (Not
2000 sheets.) This "master" row is followed by a row for each size of that
style. Each "master" contains a string that lists the sizes for that style. It
is this string that I wanted to have sorted.
> I wonder if you need to sort the sizes at all ... aren't you adding > them in
a particular order anyway?
Thanks for that suggestion! Originally the sizes for a style were in order 10,
11, 12, 13, 5, 6, 7, 8, 9. (I suspect the data were sorted with the sizes as
strings.) For some reason it never occurred to me to sort the sheet that
contains the sizes, but I just did, first by style second by size, and the data
are now in the order I need. So I don't have to do a separate sort for each
style. It was that, 2,000 sorts, that I think caused the trouble.
Once again I owe you all a great thanks, as well as my sanity.
Michael Trombetta
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
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