Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that I'm trying to use to sort:
Sheets("OPEN").Select Selection.Sort Key1:=Range("Y2"), Order1:=xlAscending, Key2:=Range("AE2") _ , Order2:=xlAscending, Key3:=Range("AB2"), Order3:=xlAscending, Header _ :=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom _ , DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _ xlSortNormal It errors out with the error: 'Runtime error "1004" Application-defined or Object-defined error' |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Writing a macro to sort and export data to multiple worksheets | Excel Programming | |||
Macro Writing | Excel Programming | |||
help writing macro | Excel Programming | |||
Help writing a macro | Excel Programming | |||
Writing 2 macros to sort names and numbers in excel 97 | Excel Programming |