Macro to remove Filters on a spreadsheet

[Peggy2015]

Hello,

How do I write VBA code that would remove the filters on a spreadsheet?

Regards,
Peggy

 

[Peter_SSs]

Does this do what you want?

Sub RemoveFltrs()
  On Error Resume Next
  ActiveSheet.ShowAllData
  On Error GoTo 0
End Sub

 

[Peter_SSs]

.. or this?

Sub RemoveFltrs2()
  ActiveSheet.AutoFilterMode = False
End Sub