Getting Rid Of Filters With VBA

[brettvba]

Is there any code to remove an autofilter from a worksheet eg autofilter.visible=false
I want it to try to remove the filter even if its not there?? any Ideas

[BabyTiger]

Hi,

You might want to try the following code:

If ActiveSheet.AutoFilterMode Then Selection.AutoFilter

HTH

[brettvba]

Thats great thanks