/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 vote181 views1 answer
Vba nested dictionary
VBA
0 vote184 views1 answer
Arq linux
VBA
0 vote159 views1 answer
How to self delete a vbscript file
VBA
1 vote183 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote214 views1 answer
Vb ternary
VBA
3 votes189 views1 answer
Vba double quote
VBA
0 vote187 views2 answers
Do until loop vba
VBA
1 vote1.3K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote196 views1 answer
Excel vba protect sheet
VBA
0 vote179 views1 answer
Excel vba delete folder
VBA