/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 vote341 views1 answer
Vba get relative cell address
VBA
15 votes478 views1 answer
Excel vba wait
VBA
0 vote329 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote341 views1 answer
Convert number to minutes in vba
VBA
0 vote357 views1 answer
Tester si une case est vide vba
VBA
1 vote328 views1 answer
Sort using vba
VBA
0 vote358 views1 answer
Iterate all file in a folder vba
VBA
8 votes502 views1 answer
Excel vba make word from bytes
VBA
0 vote356 views1 answer
Excel vba first working day month
VBA
1 vote302 views1 answer
Vba Remove Case Sensitivity
VBA