G
Guest
I don't imagine there's any solution, but I've had a number of sort problems
in Excel 2003. The one I'm currently experiencing is that Excel doesn't seem
to know Ascending from Descending - or Softie , in their infinite wisdom, is
experimenting with AI instead of following simple VB. The following code
sorts Ascending sometimes and Descending others, depending on how I manually
sort the spreadsheet in the most recent iteration. That is - if I select the
area and using the sort keys, sort in D-A-D order, it works, but if I
manually sort the sheet in D-D-D order, the macro gets confused and also
sorts in D-D-D.
As I say, it's very likely bug #1243162497162.
Calculate
Key1:=Range("Done"), Order1:=xlDescending, _
Key2:=Range("Who"), Order1:=xlAscending, _
Key3:=Range("Priority"), Order1:=xlDescending, _
Header:=xlYes, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
in Excel 2003. The one I'm currently experiencing is that Excel doesn't seem
to know Ascending from Descending - or Softie , in their infinite wisdom, is
experimenting with AI instead of following simple VB. The following code
sorts Ascending sometimes and Descending others, depending on how I manually
sort the spreadsheet in the most recent iteration. That is - if I select the
area and using the sort keys, sort in D-A-D order, it works, but if I
manually sort the sheet in D-D-D order, the macro gets confused and also
sorts in D-D-D.
As I say, it's very likely bug #1243162497162.
Calculate
Key1:=Range("Done"), Order1:=xlDescending, _
Key2:=Range("Who"), Order1:=xlAscending, _
Key3:=Range("Priority"), Order1:=xlDescending, _
Header:=xlYes, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal