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:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)