what is wrong with this macro line?
Sheets("Data1").Range("I5:J1003").Sort Key1:=Range("J5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Cheers
Ollie Riches
Sheets("Data1").Range("I5:J1003").Sort Key1:=Range("J5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Cheers
Ollie Riches