Thread: Sort a Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_8_] kirkm[_8_] is offline
external usenet poster
 
Posts: 166
Default 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