How to filter Criteria in macros

Help
1

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

2

Hi @brindhaS

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

Thanks
Ashwin.S

3

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

4

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