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

Code:
--------------------
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)


--
cjsmith22
------------------------------------------------------------------------
cjsmith22's Profile: http://www.excelforum.com/member.php...o&userid=28528
View this thread: http://www.excelforum.com/showthread...hreadid=484654