Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 1004 with sort
There is nothing wrong with that line of code. The error is something else
such as the sheet is protected or such. This is not a 2000/2003 issue (near as I can tell). One thing that is curious is that your macro is Header:=xlGuess. This requires Excel to make a guess at run time as to whether there is a header row. xlYes or xlNo would probably be more appropriate. -- HTH... Jim Thomlinson "Linking to specific cells in pivot table" wrote: Hi, The code below works fine on my computer which has Excel 2003 but is coming up with a Run-Time error 1004 on my client's computer which has Excel 2000. The actual line being highlighted by Debug is surrounded by << below. Any help is appreciated! Also, is it possible to have Excel 2003 operate in Excel 2000 mode? I ask because I have a lot of macros going on this spreadsheet and I suspect there may be more of these types of errors in the code with 2000 and would like for me to catch all the errors, not my client. Range("I15:L34").Select <<Selection.Sort Key1:=Range("I15"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Thanks! Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Run time error '1004': Generaol ODBC error | Excel Programming | |||
Run time error 1004 General ODCB Error | Excel Programming | |||
Application Run Time Error 1004 and Stack Error | Excel Programming |