Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.sort Run-time error '1004'
Hello,
I've got a problem when trying to sort a selection (Range of a worksheet). Here is the code snipped (similar to the one recorded with record a macro): With QACPackageWS Set rng = .Range(.Cells(1, 1), .Cells(row, col)) rng.Select Selection.Sort Key1:=Range("E2"), Order1:=xlDescending, Key2:=Range("G2") _ , Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _ :=xlSortNormal End With Excel/VBA stops program execution with a Run-time error '1004'. Anyone a clue what i did wrong? Thanks for Support! BR/ tilmp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
Run-time error 1004 with sort | Excel Programming | |||
Run-time error 1004 with sort | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |