/VBA/Method showalldata of object _worksheet failed vba

Method showalldata of object _worksheet failed vba

'this method should not give error "method showalldata of object _worksheet failed"
Sub ClearFiters()
    Dim MySheet As Worksheet: Set MySheet = ThisWorkbook.Sheets("MySheet")
    Dim MyTableName As String: MyTableName = "MyTable"
    MySheet.Activate
    MySheet.Range(MyTableName).Select
    Dim t As ListObject: Set t = MySheet.ListObjects(MyTableName)
    t.Sort.SortFields.Clear
    If t.AutoFilter.FilterMode Then
      MySheet.ShowAllData
    End If
End Sub

Similar codes

0 vote127 views1 answer
Excel vba automatic calculation
VBA
0 vote136 views2 answers
Vba remove line breaks
VBA
0 vote138 views1 answer
Excel vba named range exists
VBA
2 votes126 views1 answer
Excel vba check if key is in collection
VBA
27 votes248 views2 answers
Vba check if file exists
VBA
5 votes71 views1 answer
Vlookup vba
VBA
5 votes132 views1 answer
Excel vba left word from Long Integer
VBA
0 vote132 views1 answer
VBA Loop to range
VBA
0 vote121 views1 answer
Loop through lines in text file vb net
VBA
3 votes122 views1 answer
Vba folderexists
VBA