sorting a range

[cjsmith22]

i have some code which sorts a league table, firstly by column n (pts), then if pts are equal - column m (goal diff)

Range("A19:N38").Select
    Range("N19").Activate
    Selection.sort Key1:=Range("N20"), Order1:=xlDescending, Key2:=Range( _
        "M20"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase _
        :=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, _
        DataOption2:=xlSortNormal

if the values in column m are equal how do i then do an extra sort based on - columnf + columnk (goals scored)

 

[barry houdini]

One way would be to add another column with the goals for totalled (you could have this hidden if you wished), e.g. in column O and then add column O to your sort range and a 3rd key sorting on column O