Tag Archive: switch off auto filter

Sep 22

VBA – Turn off Auto Filter

Turn off Auto Filter in Active sheet   If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False     Turn off Auto Filter in Table   If Sheet1.ListObjects(“Table1”).ShowAutoFilter = True Then              Sheet1.ListObjects(“Table1”).ShowAutoFilter = False      End If