Help on adding 3rd filter criteria existing VBA

[ItalianPlatinum]

Hello - I require a minor improvement to add a 3rd filter in my existing VBA. Is someone able to help?

With Range("10:10")
    .AutoFilter
    .AutoFilter Field:=10, Criteria1:="F", Operator:=xlOr, Criteria2:="A"
    .AutoFilter Field:=11, Criteria1:=""
    .AutoFilter Field:=3, Criteria1:="<>" & Range("D5").Value2
    .AutoFilter Field:=18, Criteria1:="TRUE"
End With

For Field 10 i need to add a 3rd for the letter "C"

 

[gordsky]

would this do what you need

With range("10:10")
    .AutoFilter
    .AutoFilter Field:=10, Criteria1:=Array("F", "A", "C"), Operator:=xlFilterValues
    .AutoFilter Field:=11, Criteria1:=""
    .AutoFilter Field:=3, Criteria1:="<>" & range("D5").Value2
    .AutoFilter Field:=18, Criteria1:="TRUE"
end with

 

[ItalianPlatinum]

would this do what you need

With range("10:10")
    .AutoFilter
    .AutoFilter Field:=10, Criteria1:=Array("F", "A", "C"), Operator:=xlFilterValues
    .AutoFilter Field:=11, Criteria1:=""
    .AutoFilter Field:=3, Criteria1:="<>" & range("D5").Value2
    .AutoFilter Field:=18, Criteria1:="TRUE"
end with

Thank you!