Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort problem with first row
I am using the following code to sort first one column, then another:
Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Key2:=Range("A1") _ , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _ :=xlSortNormal however, the first row sometimes does not get sorted. How can I make sure the first row gets included in the sort? Thanks. Smokii |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort problem with first row
Hi SmokiBear,
Try changing: Header:=xlGuess to: Header:=xlNo --- Regards, Norman wrote in message oups.com... I am using the following code to sort first one column, then another: Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Key2:=Range("A1") _ , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _ :=xlSortNormal however, the first row sometimes does not get sorted. How can I make sure the first row gets included in the sort? Thanks. Smokii |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Problem | Excel Discussion (Misc queries) | |||
VBA Sort Problem | Excel Discussion (Misc queries) | |||
Sort problem - help! | Excel Discussion (Misc queries) | |||
Sort problem | Excel Discussion (Misc queries) | |||
Sort Problem | Excel Worksheet Functions |