sorts on goal difference

I assigned a macro to a button to perform this task: After inputting a round of soccer results, clicking on the button sorts the order of the league table. using the sort command I was able to sort the table firstly based on the number of points each team has. If teams are level on points, it then sorts on goal difference. If still level it then sorts on most goals scored.

Please Login or Register  to view this content.

My problem is, in the off-chance two teams are level in every way (same points, goal difference, goals scored) I'd need to sort Alphabetically, ascending. I though it'id be as simple as adding 'Key4:=Range("G3"), Order4:=xlAscending,' but this gives an error message. Can anyone advise please.


Thanks. Stuart