<div>
<div class="content wysiwyg-content">
Sub SP120others() 
 
&nbsp; &nbsp; Sheets(&quot;receivables&quot;).Select 
 
&nbsp; &nbsp; ActiveSheet.ListObjects(&quot;Table_Query_from_SME_SQL3&quot;).Range.AutoFilter Field:= _ 
&nbsp; &nbsp; &nbsp; &nbsp; 9, Criteria1:=&quot;&lt;&gt;Name One&quot;, Operator:=xlAnd, Criteria2:=&quot;&lt;&gt;Name Two&quot; 
End Sub 
 
============================================================== 
 
Would someone know how to tweak the above code to show 3 Criterias instead? Thank you.
</div>
</div>

Sub SP120others()

 Sheets("receivables").Select

 ActiveSheet.ListObjects("Table_Query_from_SME_SQL3").Range.AutoFilter Field:= _
 9, Criteria1:="<>Name One", Operator:=xlAnd, Criteria2:="<>Name Two"
End Sub

==============================================================

Would someone know how to tweak the above code to show 3 Criterias instead? Thank you.

VBA Excel Autofilter 3 Criteria

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.