/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 vote340 views1 answer
What does vbs stand for
VBA
1 vote375 views1 answer
Vba login website
VBA
22 votes481 views1 answer
Excel vba check if directory exists
VBA
3 votes358 views1 answer
Vba double quote
VBA
0 vote333 views1 answer
Ribbon show/hide
VBA
0 vote334 views1 answer
Vbnet click on dgv cells
VBA
0 vote340 views1 answer
Vba get workbook name
VBA
0 vote312 views1 answer
Vba string start with
VBA
0 vote338 views1 answer
Excel vba StartUpPosition
VBA
0 vote344 views1 answer
Vba static variable
VBA