How to filter in macros

ActiveSheet.Range("$A$1:$AL$6607").AutoFilter Field := 3, Criteria1:="<>820*", Operator:=xlFilterValues, Criteria2:="<>850-*" here for this 2 criteria it filtered it working.
but for 3 criteria how to do it ive no idea to filter

ActiveSheet.Range("$A$1:$AL$6607").AutoFilter Field := 3, Criteria1:="<>820*", Operator:=xlFilterValues, Criteria2:="<>850-" ,Operator:=xlFilterValues, Criteria3:="<>880-"
Above one is not get filtered for Three criteria

hi @brindhaS

  • symbol is missing near 880

Thanks
Ashwin S