Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel 2000 issue
My code and program were written in Excel 2003 and
everything works fine. My Excel 2000 users report a run time error 1004 when they exceute my code. When I have them push the "Debug" button they are taken to my Sort History macro where the "Selection..." section is highlighted, code attached below. Since Excel 2003 does not generate the error can you help me ID the error and a corrective action. Thanks. Sub SortHistory() Sheets("Concern History").Select Range("A2:AK25000").Select 'Debugging brings me to this point to DEBUG Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A2").Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel 2000 issue
Dan,
From looking at help in 2000, I don't believe Sort has a "DataOption1" parameter in that version. Try removing it. hth, Doug Glancy "Dan" wrote in message ... My code and program were written in Excel 2003 and everything works fine. My Excel 2000 users report a run time error 1004 when they exceute my code. When I have them push the "Debug" button they are taken to my Sort History macro where the "Selection..." section is highlighted, code attached below. Since Excel 2003 does not generate the error can you help me ID the error and a corrective action. Thanks. Sub SortHistory() Sheets("Concern History").Select Range("A2:AK25000").Select 'Debugging brings me to this point to DEBUG Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A2").Select End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel 2000 issue
hi,
re-write the code for xl2k IN xl2k. it is not wise to write code in a higher version and expect it to run in lower version. many times there are no problems but sometimes there are. developers try to make thier software backwards compatable but few can make it forward compatable. -----Original Message----- My code and program were written in Excel 2003 and everything works fine. My Excel 2000 users report a run time error 1004 when they exceute my code. When I have them push the "Debug" button they are taken to my Sort History macro where the "Selection..." section is highlighted, code attached below. Since Excel 2003 does not generate the error can you help me ID the error and a corrective action. Thanks. Sub SortHistory() Sheets("Concern History").Select Range("A2:AK25000").Select 'Debugging brings me to this point to DEBUG Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A2").Select End Sub . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel 2000 issue
hi again,
forgot an options Upgrade users to xl2003 -----Original Message----- hi, re-write the code for xl2k IN xl2k. it is not wise to write code in a higher version and expect it to run in lower version. many times there are no problems but sometimes there are. developers try to make thier software backwards compatable but few can make it forward compatable. -----Original Message----- My code and program were written in Excel 2003 and everything works fine. My Excel 2000 users report a run time error 1004 when they exceute my code. When I have them push the "Debug" button they are taken to my Sort History macro where the "Selection..." section is highlighted, code attached below. Since Excel 2003 does not generate the error can you help me ID the error and a corrective action. Thanks. Sub SortHistory() Sheets("Concern History").Select Range("A2:AK25000").Select 'Debugging brings me to this point to DEBUG Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A2").Select End Sub . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding issue in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 Font Format Issue | Excel Discussion (Misc queries) | |||
Excel 2000 Issue | Setting up and Configuration of Excel | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming |