Stop searching. Start learning and developing your excel skills.
Macro
VBA
Formula
Function
Shortcut
Tricks
» » VBA To Check If Autofilter is ON

VBA To Check If Autofilter is ON

June 03, 2017 | Labels:
This is also related to below queries:
  1. vba autofiltermode
  2. vba check if table is filtered
  3. excel vba showalldata
  4. clear autofilter vba
  5. vba filtermode
The Code:
If Activesheet.AutoFiltermode Then
   On Error Resume Next
   Activesheet.ShowAllData
   On Error Goto 0
End If
Other Excel Tutorials:
VBA To Copy Autofilter Range

This is also related to below queries: autofilter.range vba excel vba copy filtered rows to anothe ...

VBA to Copy Paste Special Values in Filtered Data

Sub CPSVFilteredData()       Dim FilteredData As Range     Dim rng As Ra ...

VBA To Filter Multiple Criteria

This is also related to below queries: vba autofilter multiple fields excel vba filter multiple cr ...

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)