title: Why does ActiveSheet.FilterMode returns False when sheet has filter?
body: <p>I'm using the following code in an attempt to detect a filter applied to a column in a table and then clear the filter:</p>
  
  <pre><code>If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData
  </code></pre>
  
  <p>According to Microsoft documentation: </p>
  
  <blockquote>
    <p>This property is true if the worksheet contains a filtered list in which there are hidden rows.</p>
  </blockquote>
  
  <p>This doesn't seem to be the case since <code>ActiveSheet.Filtermode</code> only returns <code>True</code> if a cell inside the table where the filter is applied is selected.</p>
  
  <ul>
  <li><p>First question: Is the documentation wrong? <a href="https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.filtermode.aspx" rel="nofollow">Documentation</a></p></li>
  <li><p>Second question: Is my only option to select a cell inside the table to get the expression to return True?</p></li>
  </ul>
  
  <p>PS I am using Excel 2010</p>
  
  <p>Edit: Answer to Question 2, Non-select based methods to clear filters...</p>
  
  <p><code>If ActiveSheet.ListObjects(1).Autofilter.FilterMode Then ActiveSheet.ListObjects(1).Autofilter.Showalldata</code>  </p>