Macro to sort data by a certain column

[ozzieugene]

Does anyone know how to write a macro which will sort the data by a certain column.

Only want to sort certain cells in a worksheet, not the entire worksheet

 

[JohnAcc]

What exactly do you want to sort?

You can use Data > Sort within excel to sort in ascending / Descending order any given range.

Or

You can use the advance filter to sort by using a criteria you define.

Rgds, John

 

[Loomah]

Hi
This will sort only the cells in the given range even if that range is in the middle of a larger range

Range("C1:C20").Sort Key1:=Range("C1"), Order1:=xlAscending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[ozzieugene]

Thanks for the tips.