/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 vote353 views1 answer
Excel vba move down to next visible cell
VBA
0 vote369 views1 answer
Excel filter by date not working vba
VBA
0 vote334 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote364 views1 answer
Return na vba
VBA
0 vote342 views1 answer
Vba dictionary clear
VBA
1 vote375 views1 answer
Vba ubound array 2-dimensional
VBA
18 votes555 views2 answers
Vba make word from bytes
VBA
1 vote342 views1 answer
How to do error handling in access vba
VBA
0 vote357 views1 answer
Excel vba round to whole number
VBA
0 vote348 views1 answer
Vbnet line graph smooth lines
VBA