Why does ActiveSheet.FilterMode returns False when sheet has filter?
<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>