/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

4 votes192 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote183 views1 answer
Arq linux
VBA
0 vote187 views1 answer
Find if year is leap year vb
VBA
0 vote201 views1 answer
Vba sheet hide unhide
VBA
0 vote173 views1 answer
Excel vba existence of a file
VBA
0 vote249 views1 answer
Vba array of integers
VBA
4 votes194 views2 answers
Vba create folder if not exist
VBA
9 votes242 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
6 votes184 views1 answer
Excel vba isalpha
VBA
0 vote197 views2 answers
Vb.net include quotes in string
VBA