title: Excel VBA auto filter with specific substring
body: <p>I have multiple row with different strings in which I want to filter data which are in this order </p>
  
  <p>"DI then numbers" i.e <strong>DI07493A</strong>.</p>
  
  <p>Column values are as such below:</p>
  
  <p>01LICIN</p>
  
  <p>05LICIN</p>
  
  <p>AARHUSK</p>
  
  <p><strong>DI07493A</strong></p>
  
  <p>ABS16</p>
  
  <p>DICOFDI</p>
  
  <p><strong>DI94193A</strong></p>
  
  <p>I am trying like this.</p>
  
  <pre><code>sheet1.Range("A1:A" &amp; LastRow).AutoFilter Field:=4, Criteria1:= DI &amp; #, Operator:=xlFilterValues
  </code></pre>
  
  <p>its not working. Is there a way to get this result?</p>