Sort selection

[dutchninja]

Good morning,

I'm looking for the code for sorting a selection. (in excel 2010)
This selection can be different anytime and I want to sort on columns R, E and F (asc, asc, asc)

So, I select rows 1 till 10 and sort them.
Next day, I add a row, so rows 1 till 11 needs to be sorted. or row 345 till 456, etc.

I want to add this code to a button because when using the standard Excel button, everytime I have to fill in the columns manually.

Anyone knows?

Thanks !

 

[wigi]

For instance:

Sub f()
    With Selection
        .Sort Range("R" & .Row), , Range("E" & .Row), , , Range("F" & .Row), Header:=xlNo
    End With
End Sub

 

[dutchninja]

Great,

quite simple, but very effective!
Thanks!

 

[Papi]

Wigi,

I have been needing something like this for a long time. You just solved my issue as well. Thank you.

 

[wigi]

Wigi,

I have been needing something like this for a long time. You just solved my issue as well. Thank you.

No thanks, you're welcome

 

[Papi]

The code was working great until I changed a couple of columns around and ran the same code with a different selection i.e. Column C first, Column D second and Column E third but now the sort is including the header row along with the sort and moving it from the header. Any idea of what I am doing wrong...

Sub Sort_Quotes()
With Selection
.Sort Range("C" & .Row), , Range("D" & .Row), , , Range("E" & .Row), Header:=xlNo
End With
End Sub

 

[Papi]

Bump...Might this have to do with the fact there is a header row?