Thread: Sort a Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default 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