Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 - 2000 incompatability
I've got an Excel application that was written in 2003. Now I find out I
have a user that is still using 2000, and at least one segment of my 2003 code is not working. I have a routine that selects a worksheet, and sorts it by a particular field. When this user runs this code, it bomb on the last line of the code provided below. Selection.Sort Key1:=Range("A2"), _ Order1:=xlAscending, _ Header:=xlYes, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal I don't know whether this is because Excel 9.0 is not recognizing the DataOption1 or the xlSortNormal, or something else in the Sort method. Would greatly appreciate if someone could provide the correct code to run this in Excel 9.0. Thanks. -- Don''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2000 vs. 2003 | Excel Programming | |||
Pie chart built in 2000, now in 2003 but unable to edit 2003-way | Excel Discussion (Misc queries) | |||
i'm doing ecdl using 2003 but only have 2000? | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
VBA and 2002/2003/2000 | Excel Programming |