Sort a Range

[kirkm]

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

 

[CurlyDave]

"....... 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

 

[kirkm]

"....... 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