title: Excel advanced filter not returning any data
body: <p>Trying to get a working filter for quick report building - as seen <a href="https://chandoo.org/wp/2012/11/27/extract-subset-of-data/" rel="nofollow noreferrer">here</a>.</p>
  
  <p>My code at the moment reads like this:</p>
  
  <pre><code>Option Explicit
  Sub GetData()
  
  'Clear data field
  
      Sheets("Filter").Select
      Range("B10").Select
      Range(Selection, Selection.End(xlToRight)).Select
      Range(Selection, Selection.End(xlDown)).Select
      Selection.Clear
  
  'Advanced Filter code
  
      Sheets("RawData").Range("JobRegister[#All]").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
          Sheets("RawData").Range("W1:AA2"), CopyToRange:=Sheets("Filter").Range("B10:T10"), Unique:=True
  
  
  
      Range("B10").Select
  
  End Sub
  </code></pre>
  
  <p>And it only returns the column headers and no results, regardless of what I use as criteria. </p>
  
  <p>My criteria filters look like this:</p>
  
  <pre><code>=IF(Filter!C4="Any","",Filter!C4)
  </code></pre>
  
  <p>Where C4 contains a DV list drawn from another sheet.</p>
  
  <p>I had it sort of working temporarily (it would filter for some criteria, not others) but I don't know what it was that I did to make it work nor why it's not working any more!</p>