Remove Filter From ListObject Table

[efernandes67]

Hi,

I have workbook with several worksheets, and I need to remove the filters in a ListObject "Table1". How can I do it without having to select the worksheet where the table is and the table itself?

Please Login or Register  to view this content.

Regards,
Elio Fernandes

[Leith Ross]

Hello Elio,

This line of code will turn the filters off for the ListObject named "Table1" on the worksheet "Pets". This affects only the list filters, not the worksheet filters.

Please Login or Register  to view this content.

[efernandes67]

Thanks Ross.

Elio Fernandes