If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False
Will remove the autofilter if it is active
In a given worksheet, is it possible to create a macro that detects the presence of any active autofilter (in a range of columns, for example from column1 to 10) and remove them?
sorry i think i explained myself badly. I would like to remove only the value of any autofilter, not the existance of the autofilter itself.
If, for example, autofilter is active and column "B" contains names and has an active filter on name "Mario", i would like the macro to remove it.
If you mean to delete all of the information for the filtered range, then change the line to:
If you have more than 1000 rows, then change the number. This will clear all of the filtered records in the columns A to J
Hi Bill, thank you very much for your help. I will now try your solutions thanks you Derry also
Just out of Interest ... if the autofilter is over a large number of rows releasing the autofilter can take more than a few seconds of processing time ... yet if you select the drop down tab of the column being filtered it is almost instant .... my question is How come?.
There are currently 3 users browsing this thread. (0 members and 3 guests)