/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 vote229 views1 answer
Vba full date format
VBA
4 votes181 views2 answers
Vba last row
VBA
0 vote253 views1 answer
Excel vba protect scenarios
VBA
2 votes297 views1 answer
Vba round number
VBA
0 vote226 views1 answer
Vba remove numbers from string
VBA
0 vote224 views2 answers
Excel vba copy paste after last row
VBA
-1 vote268 views1 answer
How save excel through visual basic
VBA
0 vote256 views1 answer
Selecttoken em vbnet e json
VBA
3 votes246 views1 answer
Vba double quote
VBA
0 vote222 views1 answer
Le contrôle SpinButton (Toupie)
VBA