title: VBA Filter multiple ctiteria in sting type
body: <p>I am trying to write a code for a autofilter, the aim is to filter around 10 criteria, each of them is a string such as <code>M1454</code> (in another word, as long as the data contain <code>M1454</code>) then it will be filtered). But I am having problem using array for the string criteria. Here is the code I used using exact criteria: </p>
  
  <pre><code>Sub AutoFilter()
      'Select the whole worksheet for filter'
       ActiveWorkbook.ActiveSheet.Range("A:BB").Select
  
       'Set the condition for BType'
       Selection.AutoFilter Field:=15, Criteria1:=Array( _
           "M1454H", "M1643D", "M1670D", "M1736A", "M1747B", "M1747C", _
           "M1766B", "M1796B", "M1796Z", "M1867A", "M1867B", "M1947B", _
           "M2617A", "M4886A"), Operator:=xlFilterValues
  End Sub
  </code></pre>
  
  <p>But if I change the criteria from <code>M1454H</code> to <code>*M1454*</code> then error shows up. Do anyone have any idea why this happen, thank you :) </p>