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