Remove Autofilter

yogeshyl · June 8th, 2007, 02:33 AM

Please guide how to remove the autofilter applied previously to the range of cells.

Yogesh

malik641 · June 9th, 2007, 03:26 PM

Hi Yogesh,

You should first check if the Sheet has an Autofilter applied first, and if so, then all you have to do is just create an autofilter on any range to turn it off. Something like:

Code:

Sub TurnOffAutofilter()
    If Worksheets("Sheet1").AutoFilterMode = True Then _
        Worksheets("Sheet1").Range("A1").AutoFilter
End Sub

Hope this helps :)

yogeshyl · June 11th, 2007, 03:58 AM

Thanks malik, i got the solution by using the bewlo statement.
ActiveSheet.AutoFilterMode = False

Yogesh

yogeshyl · June 11th, 2007, 03:59 AM

Thanks malik, i got the solution by using the below statement.
ActiveSheet.AutoFilterMode = False

Yogesh

malik641 · June 11th, 2007, 06:59 AM

Ah yes. Forgot about that.

Glad to see you got it going :)