Sorting column data ascending

[Apple08]

Hi everyone

I would like to sort the column F in ascending with row one as header. The spreadsheet have 13 columns up to column M, I have done the code below but it needs debug:

  Range("A2:M", Range("F" & Rows.Count).End(xlUp)).Sort _
    Key1:=Range("F2"), Order1:=xlAscending

Please could anyone tell me how to amend it? Many thanks.

 

[vcoolio]

Hello Apple08,

Try the following:-

Sheet1.Range("A2", Sheet1.Range("M" & Sheet1.Rows.Count).End(xlUp)).Sort Sheet2.[F2], 1

It should sort all columns (ascending) based on Column F.

I've assumed Sheet1 to be the active sheet. Change this to suit (but please note that Sheet1 is the sheet code not the sheet name).

I hope that this helps.

Cheerio,
vcoolio.

 

[Apple08]

It works perfectly! Many thanks!

 

[vcoolio]

You're welcome Apple08. I'm glad that I was able to help.

Cheerio,
vcoolio.