/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 vote163 views1 answer
Create links in msgbox in vb
VBA
1 vote169 views1 answer
How to remove zeros in excel
VBA
0 vote208 views1 answer
Find control with name vb
VBA
0 vote156 views1 answer
Excel vba delete folder
VBA
0 vote158 views1 answer
Rotate image by any angle vb.net
VBA
8 votes158 views1 answer
Excel vba make a short integer from two bytes
VBA
1 vote149 views1 answer
What does vbs stand for
VBA
0 vote159 views1 answer
Vba get application version
VBA
0 vote148 views1 answer
Change "location" of binding navigator vb
VBA
0 vote157 views1 answer
Excel vba cell on change
VBA