/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 vote227 views1 answer
Nested if else in vb.net
VBA
1 vote223 views1 answer
Vba date to unix timestamp
VBA
4 votes218 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote239 views1 answer
Label de tableau dans des label.text en VBA
VBA
1 vote231 views1 answer
Excel vba to lower case
VBA
0 vote233 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote229 views1 answer
Vba dropdown event
VBA
0 vote220 views1 answer
Excel vba range contains
VBA
1 vote211 views1 answer
Vba listindex select multiple items vba
VBA
0 vote211 views2 answers
Excel vba prevent save
VBA