G
Guest
When I try to insert a criteria in an Autofilter using a macro, NO results
are shown. Even when I record the macro, and it works perfectly while
recording, when I run the macro; No results are shown. I used the following
code:
Selection.AutoFilter Field:=5, Criteria1:=">29-4-2003", Operator:=xlAnd, _
Criteria2:="<5-5-2003"
Can anybody see the problem (or even beter; the sollution)? Thanks in advance!
are shown. Even when I record the macro, and it works perfectly while
recording, when I run the macro; No results are shown. I used the following
code:
Selection.AutoFilter Field:=5, Criteria1:=">29-4-2003", Operator:=xlAnd, _
Criteria2:="<5-5-2003"
Can anybody see the problem (or even beter; the sollution)? Thanks in advance!