I have problems when applying the following code
ActiveSheet.Range("$A$1:$B$7").AutoFilter Field:=1, Criteria1:= _
"<01.08.2018", Operator:=xlAnd
When the macro activates the filter. All values are filtered and are not visible in the list (values larger, equal and lower than
ActiveSheet.Range("$A$1:$B$7").AutoFilter Field:=1, Criteria1:= _
"<01.08.2018", Operator:=xlAnd
When the macro activates the filter. All values are filtered and are not visible in the list (values larger, equal and lower than
01.08.2018
After running the macro the filter function is activates and have the correct values (Date filter, before , 01.08.2018. When filtering manually using the values set by the macro, excel gives a perfect list
When removing the < the macro result gives a correct filtered list with values equal to 01.08.2018
What may cause this problem?
After running the macro the filter function is activates and have the correct values (Date filter, before , 01.08.2018. When filtering manually using the values set by the macro, excel gives a perfect list
When removing the < the macro result gives a correct filtered list with values equal to 01.08.2018
What may cause this problem?