/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

1 vote271 views1 answer
Ms access open form to new record
VBA
0 vote317 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote336 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote331 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote318 views1 answer
Freeze panes vba
VBA
2 votes334 views1 answer
Vba file from path
VBA
5 votes365 views2 answers
Excel vba write to the windows registry
VBA
-1 vote289 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote316 views1 answer
Vba border weight
VBA
0 vote378 views1 answer
Winforms dark title bar
VBA