How to remove all filters from the current active Worksheet

[John_Daly]

Hi All,

I am looking to remove all current filters from the current worksheet. The filters could be on any column or row. Is it possible to have a 'remove all' filters macro?

Thanks in advance.

Regards,
John

 

[Anonymous1378]

Applying a filter to a single cell (Ctrl-Shift-L) will remove existing autofilters on the sheet, and fail to create a filter if there isn't. Won't that suffice if you only care about the current active sheet?

 

[John_Daly]

Thanks for your reply - An automated job will be carrying out this function so I would be looking to call a stored macro

 

[RoryA]

If you are not using tables, then simply activesheet.autofiltermode = false will do the trick.