Organizing range of cells using Excel VBA

Question

I have data about 400 rows in columns B through U. Column F is the one in where dates are posted. I need to have it where all the data is organized by column F, without messing up the rest of the cells adjoining it.

Is this possible? If so how?

Answer 1

Range("F1").Sort key1:=Range("F1"), order1:=xlAscending

If you have some header rows that shouldn't sorted you'll need specify the complete Range to be sorted (e.g. Range("B2:U10").Sort...) instead. Replace order1 with xlDescending if you want it descending instead.