Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort a Range
I wonder if there's a quick way to do this - In my worksheet I'd like to sort (everything in) rows 112-151 by the value in column C. Thanks for any help. My way would be to read it all into an array, and sort that by element 3, then re-write the rows. But I suspect a much easier and faster Excel method might exist. Cheers - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort a Range
"....... But I suspect a much easier and *faster Excel method might
exist......" Like selecting the rows and sorting based on Column C? Or with VBA Rows("112:151").Sort Key1:=Range("B111"), Order1:=xlAscending, Header:=xlNo _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort a Range
On Thu, 26 Feb 2009 02:28:29 -0800 (PST), CurlyDave
wrote: "....... But I suspect a much easier and *faster Excel method might exist......" Like selecting the rows and sorting based on Column C? Yes, I stumbed onto that after posting the message :) Or with VBA Rows("112:151").Sort Key1:=Range("B111"), Order1:=xlAscending, Header:=xlNo _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Thanks for that too, Cheers - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Worksheet Range from another worksheet range, Excel 2000 & 2003 | Excel Programming | |||
Search range and sort another range | Excel Programming | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Sort range changes during sort | Excel Discussion (Misc queries) | |||
Range.Sort in VBA | Excel Programming |