title: How to automatically use * wildcard on a Excel AutoFilter macro?
body: <p>I have a macro in Excel that filters my table when it is activated by a button.</p>
  
  <p>This is the macro:</p>
  
  <pre><code>Sub Macro2()
  '
  ' Macro2 Macro
  '
      ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2, Criteria1:= _
          Range("D1").Value
  End Sub
  </code></pre>
  
  <p>The macro is filtering the table using the field 2 and the value on D1 cell.</p>
  
  <p><strong>How do I make it use the * wildcard?</strong></p>
  
  <p>For example, if the name is <code>Maria Doe</code> and the cell is <code>Maria</code> it won't show in filter. But if the cell is <code>Maria*</code> it will show in filter. </p>
  
  <p>I think the issue has to do with the <code>criteria:=</code> parameter, but I'm not sure how to set it.</p>