Hi all,
I have a problem passing a value from a cell into the custom filter in autofilter.
Can some one pleases look at the below code and let me know where I go wrong? (the criteria for field 2 works as it should).
Thank you in advance.![]()
Sub SelectionFilter() Rows("6:6").Select Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:=Range("B3") Selection.AutoFilter Field:=1, Criteria1:=">=" & Range("C3"), Operator:=xlAnd, Criteria2:="<=" & Range("D3") End Sub
Greetings.
Bookmarks