/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 vote225 views1 answer
Vba option button selected
VBA
0 vote244 views1 answer
Add text to Shape VBA
VBA
0 vote263 views1 answer
Vba ternary
VBA
0 vote280 views1 answer
Excel vba delete columns in range
VBA
0 vote230 views1 answer
Vba format currency
VBA
0 vote240 views1 answer
Vba dictionary clear
VBA
0 vote242 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote225 views1 answer
Vbnet get file name from path
VBA
0 vote229 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote264 views4 answers
Vgrive,deb
VBA