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











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks