Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem sorting in Excel 2000 vs. 2003
I have a macro that sorts the following code fine in Excel 2003 but stops the
macro in Excel 2000. Here is the code that is not working in Excel 2000. Any suggestions are appreciated: Range("A5:S5000").Select Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal -- David P. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem sorting in Excel 2000 vs. 2003
DataOption1:=xlSortNormal
Was added in xl2002. Delete it from your code and you should be ok (don't forget the preceding comma and underscore, too). David P. wrote: I have a macro that sorts the following code fine in Excel 2003 but stops the macro in Excel 2000. Here is the code that is not working in Excel 2000. Any suggestions are appreciated: Range("A5:S5000").Select Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal -- David P. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem sorting in Excel 2000 vs. 2003
That's fantastic Dave. Thanks so much.
-- David P. "Dave Peterson" wrote: DataOption1:=xlSortNormal Was added in xl2002. Delete it from your code and you should be ok (don't forget the preceding comma and underscore, too). David P. wrote: I have a macro that sorts the following code fine in Excel 2003 but stops the macro in Excel 2000. Here is the code that is not working in Excel 2000. Any suggestions are appreciated: Range("A5:S5000").Select Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal -- David P. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem sorting in Excel 2000 vs. 2003
We "David P.'s" have to stick together!
David P. wrote: That's fantastic Dave. Thanks so much. -- David P. "Dave Peterson" wrote: DataOption1:=xlSortNormal Was added in xl2002. Delete it from your code and you should be ok (don't forget the preceding comma and underscore, too). David P. wrote: I have a macro that sorts the following code fine in Excel 2003 but stops the macro in Excel 2000. Here is the code that is not working in Excel 2000. Any suggestions are appreciated: Range("A5:S5000").Select Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal -- David P. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem copying visible cells from 2000 to 2003 | Excel Discussion (Misc queries) | |||
Problem with Excel 2000 / 2003 | Excel Discussion (Misc queries) | |||
Calender Object problem in Excel 2000 and 2003 | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
sorting problem in excel 2000 | Excel Discussion (Misc queries) |