Answered by : cs

Sub ResetFilters() On Error Resume Next ActiveSheet.ShowAllData
End Sub

Source : https://stackoverflow.com/questions/18226045/showalldata-method-of-worksheet-class-failed | Last Update : Wed, 25 May 22