Sorting problem 2003 vs 2007

Hi All,

The code below works fine on a machine running Excel 2003 but when transferred to a machine running Vista with Excel 2007 I get a “Run time Error 1004”

Is there a way to have the same code run on both versions?

PS I have deliberately done all my development in 2003 believing that it would all work on 2007 but that it would not work the other way around. Am I correct?

Regards,

Alan

FinalRow = Cells(Rows.count, 1).End(xlUp).Row
 Range("A2:Z" & FinalRow).Select
    Selection.Sort Key1:=Range("T2"), Order1:=xlAscending, Key2:=Range("S2") _
        , Order2:=xlAscending, Key3:=Range("V2"), Order3:=xlAscending, Header:= _
        xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
        xlSortNormal