I am trying to sort on 2 seperate columns, but it always gives me an error ont he second one.With Activesheet.Range(Cells(1, 1), Cells(1, RightCol)) .AutoFilter Field:=4, Criteria1:=Router .AutoFilter Field:=16, Criteria1:=IP End With
"Autofilter method on Range class failed."
The first one always goes through but never the second. Can someone tell me how to accomplish what im trying to do?
Bookmarks