Try changing this line:
to this:![]()
Rng.AutoFilter Field:=1, Criteria1:=">=" & r1, Operator:=xlAnd, Criteria2:="<=" & r2
![]()
Rng.AutoFilter Field:=1, Criteria1:=">=" & r1.Value2, Operator:=xlAnd, Criteria2:="<=" & r2.Value2
Try changing this line:
to this:![]()
Rng.AutoFilter Field:=1, Criteria1:=">=" & r1, Operator:=xlAnd, Criteria2:="<=" & r2
![]()
Rng.AutoFilter Field:=1, Criteria1:=">=" & r1.Value2, Operator:=xlAnd, Criteria2:="<=" & r2.Value2
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks