Clear a Filter in VBA

[KHaag]

I have a Macro that opens another file and unfilters the file before using it.

I'm using the code: ActiveSheet.ShowAllData
ActiveSheet.Range($A$6:$AF$172).AutoFilter Field:=26, Critical:="="

If the file happens to not be filtered, I get a debug error. I did get this code by recording the Macro.

Is there code to simple tell Excel to clear any and all filters?

Thank you,
Kim

 

[Fluff]

How about

   ActiveSheet.AutoFilterMode = False

 

[KHaag]

Hello Fluff,
This worked!!! And it was SO simple!!!
Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.