Excel VBA Remove Filter From Table

Question

I am trying to create a macro that will create a table and then remove the filter in the header row. To clarify, I want the filter itself totally removed from the table. Looking on other threads, it is difficult to discern whether people simply want their filters to say "Select all" or whether they want the filters themselves removed.. I want the filters themselves gone.

Any help would be appreciated! I am not the greatest with VBA and can't seem to find anyone on Google with similar ambitions using Excel.

if you know how to create a macro you will know that doing it aint that hard, add your efforts, sho the community that you have done you r homework — Muhammad Omer Aslam
– Muhammad Omer Aslam, Commented Dec 2, 2017 at 22:49

Carol · Accepted Answer · 2017-12-02 22:43:01Z

1

This should toggle the filter on/off in a table. So, run it once, it turns the filter off, run it again to turn the filter on.

Sheets("Sheetname").ListObjects("TableName").Range.AutoFilter

answered Dec 2, 2017 at 22:43

Carol

4714 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Hutter · Accepted Answer · 2018-09-24 19:45:12Z

1

The variant I like most is the following:

Sub ResetFilters()
    On Error Resume Next
    ActiveSheet.ShowAllData
End Sub

answered Sep 24, 2018 at 19:45

Michael Hutter

1,6721 gold badge18 silver badges39 bronze badges

Comments

Michael Hutter · Accepted Answer · 2018-09-24 19:32:54Z

0

To turn off a filter simply use

Cells.AutoFilter

or

Sheets("Sheetname").Cells.AutoFilter

answered Sep 24, 2018 at 19:32

Michael Hutter

1,6721 gold badge18 silver badges39 bronze badges

Comments

Baki · Accepted Answer · 2020-07-07 17:51:51Z

0

I find that the ListObjects.Range.AutoFilter does not work when the vba code is triggered by a button, since pressing the button again would toggle the filter back on. In that case you can use:

Sheets("Sheetname").ListObjects("TableName").ShowAutoFilterDropDown = False

answered Jul 7, 2020 at 17:51

Baki

1

Collectives™ on Stack Overflow

Excel VBA Remove Filter From Table

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related