/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 vote281 views1 answer
Vlookup columns not next to each other
VBA
1 vote273 views1 answer
How to do error handling in access vba
VBA
2 votes280 views1 answer
Excel vba date to string conversion
VBA
0 vote308 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote299 views1 answer
Selecttoken em vbnet e json
VBA
8 votes377 views1 answer
Vba make a short integer from two bytes
VBA
2 votes304 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote280 views1 answer
Vba file size
VBA
4 votes292 views2 answers
Excel vba last column with data
VBA
0 vote271 views1 answer
Do until vb.net
VBA