Check if autofilters are on

[gaj104]

Hi

What code would I use to check if there are autofilters in a specific sheet, and hense remove them if they exist.

Many thanks

 

[Richard Schollar]

Hi

If Activesheet.AutofilterMode Then 'autofilter is on

Best regards

Richard

 

[Andrew Poulsom]

Check out the worksheet's AutoFilterMode property in VBA Help.

 

[Peter_SSs]

gaj104

Try:

ActiveSheet.AutoFilterMode = False
to remove the AutoFilters altogether.

ActiveSheet.ShowAllData
to leave the AutoFilter available but 'unfilter' everything.

 

[gaj104]

Hi

Code:
If Activesheet.AutofilterMode Then 'autofilter is on


Best regards

Richard

Perfect. Thanks

 

[Peter_SSs]

Hi

Code:
If Activesheet.AutofilterMode Then 'autofilter is on


Best regards

Richard

Perfect. Thanks

What about this part?

..and hense remove them if they exist.