/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 vote306 views1 answer
Vba len variant
VBA
0 vote296 views1 answer
Check range is in another range vba
VBA
1 vote261 views1 answer
Ms access open form to new record
VBA
0 vote318 views1 answer
Excel VBA web scraping
VBA
0 vote328 views1 answer
Vba clear collection
VBA
0 vote298 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
5 votes317 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote278 views1 answer
How to make a if statement with vbs
VBA
0 vote323 views1 answer
Rotate image by any angle vb.net
VBA
0 vote305 views1 answer
Vbnet get file name from path
VBA