/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 vote139 views1 answer
Excel vba close form escape key
VBA
1 vote137 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote157 views1 answer
Excel vba paste all to each sheet in workbook
VBA
27 votes264 views2 answers
Vba check if file exists
VBA
0 vote145 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
-1 vote148 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
8 votes159 views1 answer
Excel vba make integer
VBA
22 votes263 views1 answer
Xlvba check for folder
VBA
0 vote132 views1 answer
Replace spaces with underscores vbnet
VBA
-1 vote126 views2 answers
How close excel through visual basic
VBA