Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 1004
Anyone - help!
I've got this scenario: Excel 2002 with a sheet where the followng error comes up: Run-time error '1004' Application-defined or object-defined error. When I start the debugger the following VBA line comes up: Cells.Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub I can't see the error here. Please help - and merry Christmas to You all! --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 1004
If that's all the code then the error may be caused
because you haven't specified which worksheet you are referring to. Try: ActiveSheet.Cells.Select -----Original Message----- Anyone - help! I've got this scenario: Excel 2002 with a sheet where the followng error comes up: Run-time error '1004' Application-defined or object-defined error. When I start the debugger the following VBA line comes up: Cells.Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub I can't see the error here. Please help - and merry Christmas to You all! --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004' | Excel Discussion (Misc queries) | |||
Run time error 1004! | Excel Discussion (Misc queries) | |||
run time error 1004 | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |