Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Problem
excel 2007
what's wrong with the following sort? Sub Macro1() Range("B3").Select lastrow = Range("B" & Rows.Count).End(xlUp).Row Set SortRange = Rows("3:" & lastrow) SortRange.Sort , key1:=Range("C2"), _ order1:=xlAscending, _ key2:=Range("B2"), _ order2:=xlAscending, _ Header:=xlYes End Sub It stops at SortRange.Sort |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Problem
What about this: FirstRow = 2 lastrow = Range("B" & Rows.Count).End(xlUp).Row Set SortRange = Range("B" & FirstRow & ":C" & lastrow) SortRange.Sort Key1:=Range("C1"), Order1:=xlAscending, Key2:=Range("B1"), Order2:=xlAscending, Header:=xlGuess HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Helmut" wrote: excel 2007 what's wrong with the following sort? Sub Macro1() Range("B3").Select lastrow = Range("B" & Rows.Count).End(xlUp).Row Set SortRange = Rows("3:" & lastrow) SortRange.Sort , key1:=Range("C2"), _ order1:=xlAscending, _ key2:=Range("B2"), _ order2:=xlAscending, _ Header:=xlYes End Sub It stops at SortRange.Sort |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem sorting | Excel Worksheet Functions | |||
sorting problem 10 comes before 8 | Excel Worksheet Functions | |||
Another sorting problem | Excel Discussion (Misc queries) | |||
sorting problem | Excel Discussion (Misc queries) | |||
Sorting Problem Need | Excel Programming |