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

Leave a Reply

Your email address will not be published.