/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 vote209 views1 answer
Vba change named range address
VBA
0 vote223 views1 answer
Ribbon show/hide
VBA
3 votes198 views1 answer
Excel vba read registry key value
VBA
0 vote204 views1 answer
Vba paste values
VBA
1 vote202 views1 answer
Excel vba first row in range
VBA
0 vote220 views3 answers
Write to text file vb.net
VBA
2 votes204 views2 answers
Excel vba copy values range to another range
VBA
0 vote208 views1 answer
Excel vba center userform
VBA
0 vote193 views1 answer
Create new worksheet excel visual basic
VBA
0 vote221 views2 answers
Excel vba copy paste after last row
VBA