i have 2 identical section of code giving 2 different results, they are both supposed to sort a section of a sheet in order from oldest date 2 newest but one does it and the other doesnt, the only difference is the cell references, can anyone advise please
Selection.AutoFilter Field:=3, Criteria1:="<>"
Range("A3:D160").Select
Selection.Sort Key1:=Range("C3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Selection.AutoFilter Field:=3
Selection.AutoFilter Field:=8, Criteria1:="<>"
Range("F3:I160").Select
Selection.Sort Key1:=Range("H3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Selection.AutoFilter Field:=8
Bookmarks