/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

1 vote192 views1 answer
Vba exit do while
VBA
1 vote262 views1 answer
Find and replace textbox
VBA
0 vote245 views1 answer
Search combobox items vb.net
VBA
0 vote261 views1 answer
Vba count all row
VBA
5 votes247 views1 answer
Excel vba low byte from INTEGER
VBA
18 votes328 views3 answers
Excel-vba make integer
VBA
0 vote244 views1 answer
Make all controls in an area not visable vb
VBA
0 vote256 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote242 views1 answer
Excel run macro every 5 minutes
VBA
0 vote269 views1 answer
Move bindingnavigator vb
VBA