/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 vote165 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote178 views1 answer
Add rows to datagridview vb.net
VBA
0 vote166 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote178 views1 answer
Convert number to minutes in vba
VBA
0 vote219 views1 answer
Visual basic cmd
VBA
0 vote206 views1 answer
Vbnet check if string is only numbers
VBA
1 vote193 views1 answer
Perform http request in vb.net
VBA
1 vote170 views1 answer
Excel vba get column name from number
VBA
5 votes168 views1 answer
Excel vba high word from Long Integer
VBA
0 vote164 views1 answer
Type excel.application is not defined vb
VBA