vba Autofilter with wildcard has error .Range("A" & .Rows.Count).AutoFilter Field:=1, Criteria1:="<>" & FundingDivFilter & "*", Operator:=xlAnd

[Tesla]

The Objxl is just a reference to Excel in the MSAccess vba application.
The Access - SQL Server application takes data back and forth to Excel. Lots of Remote automation
FundingDivFilter is a string variable.

The Normal filter is well known. One filter will work if there is a wild card (*)
' Fails
objxl.Range("A" & .Rows.Count).AutoFilter Field:=1, Criteria1:="<>" & FundingDivFilter & "*", Operator:=xlAnd
' Works in dozen of other places
objxl.Range("A" & .Rows.Count).AutoFilter Field:=1, Criteria1:="<>" & TransactionCategory, Operator:=xlAnd

 

[Norie]

Have you tried without Operator:=xlAnd?