User Tools

Site Tools


microsoft_excel:macros:filters:turn_filters_off

Microsoft Excel - Macros - Filters - Turn Filters off

' Removes AutoFilter if one exists.
Sub TurnFilterOffAllSheets()
 
    Dim ws As Worksheet
 
    For Each ws In ActiveWorkbook.Worksheets
        With ws
            .AutoFilterMode = False
        End With
    Next ws
 
End Sub
microsoft_excel/macros/filters/turn_filters_off.txt · Last modified: 2021/08/04 15:50 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki