G
Guest
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
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