Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Message: Sort Method of Range Class Failed
I want my marco button to sort my POLICYLIST named range by A5, then by P5,
but it's not working. What am I doing wrong? Application.Goto Reference:="POLICYLIST" Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Key2:=Range("P5") _ , Order2:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:= _ xlSortNormal Range("B5").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select method of Range class failed error message | Excel Programming | |||
Select method of Range class failed error message | Excel Programming | |||
Select method of Range class failed error message | Excel Programming | |||
sort method of range class failed | Excel Programming | |||
Error Message Copy method of worksheet class failed | Excel Programming |