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