/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 vote125 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote126 views1 answer
Vbs
VBA
0 vote114 views1 answer
Vba len variant
VBA
0 vote127 views1 answer
VBA is form loaded
VBA
0 vote108 views1 answer
Enter into cells data grid view
VBA
0 vote124 views1 answer
Get current url vb.net
VBA
0 vote126 views1 answer
Write listbox to text file vb.net
VBA
1 vote118 views1 answer
Excel vba unload userform
VBA
0 vote129 views1 answer
Group controls programmatically vb
VBA
0 vote119 views2 answers
How to concatenate more than 40 lines in vba
VBA