Excel 2013 VBA Clear All Filters macro
excel, macos, vba
Solution
If the sheet already has a filter on it then:
Sub Macro1()
Cells.AutoFilter
End Sub
will remove it.
Problem
It seems older macros are not working. I have proper securtiy set to run VBA macros but when I have tried a few methods for clearing ALL filters on a worksheet, I get a compile error. Here is what I have tried: ``` Sub AutoFilter_Remove() 'This macro removes any filtering in order to display all of the data but it does not remove the filter arrows ActiveSheet.ShowAllData End Sub ``` ` I have buttons on the sheets to clear all filters for ease of use for users since the sheets has a lot of columns that have filters on them.