/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

5 votes166 views1 answer
Excel vba right word from Long Integer
VBA
1 vote161 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote145 views1 answer
Vba like with wildcard
VBA
0 vote158 views2 answers
Excel vba number format file size
VBA
0 vote149 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote153 views1 answer
Vba file chooser
VBA
0 vote160 views1 answer
Vbs run with cscript
VBA
0 vote151 views1 answer
Vba html document reference
VBA
0 vote144 views1 answer
Get current year vb
VBA
0 vote176 views1 answer
Excel vba move down to next visible cell
VBA