title: If statement for detecting autofilter, even when nothing has been filtered
body: <p>I've had a search around for this but havn't found anything yet. To clarify, I'm looking for a simple if statement for applying an autofilter if none exists, or do nothing if there is one already in place.</p>
  
  <p>I thought the solution would be:</p>
  
  <pre><code>If ActiveSheet.FilterMode = False Then
      Selection.AutoFilter
  end if
  </code></pre>
  
  <p>but this only detects filtered data. If a filter is already in place and you execute this line...</p>
  
  <pre><code>Selection.AutoFilter
  </code></pre>
  
  <p>The filter vanishes, and my code has a bad day. Is there a simple solution to this?</p>