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
|