How to filter Criteria 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 i’ve 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

Have you tried it in .xlsm format where you can run manually

Thanks
Ashwin.S

It doesn’t work this way. Keep your filter values in an array rather than using three criteria’s. for example Criteria1:=myArray

Cheers @brindhaS

I’ve given values in array, but I cannot specify the condition (<>)along with my values

ActiveSheet.Range("$A$1:" & sCol & lastrow).AutoFilter Field:=3, Criteria1:=Array("<>820*", “<>850*”, “<>880*”), Operator:=xlFilterValues

my value 820-000001like this
here i want to filter in excel except this above value