title: Excel VBA: How to Unfilter Only One Autofilter Range at a Time? Code Provided
body: <p>Thanks for coming to this thread. </p>
  
  <p><strong>What I have:</strong></p>
  
  <p>-A report with an autofilter on rows A:G</p>
  
  <p><strong>What I need:</strong></p>
  
  <p>-Circumstantial code that unfilters a specific column if there is a filter on it.</p>
  
  <p>-Running my code below unfilters the entire range of A:G.</p>
  
  <p>-In this instance, I only want "F" unfiltered, leaving any other filters alone if they are filtered.</p>
  
  <pre><code>With Sheets("DATA")
      If .Range("F1").AutoFilter = True Then
          ActiveSheet.Range("$A$1:$G$59826").AutoFilter Field:=6
      Else
      End If
  End With
  </code></pre>
  
  <p>Any and all ideas are greatly appreciated! Thank you so much!</p>