/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 vote217 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote209 views1 answer
Excel vba disable alerts
VBA
0 vote288 views1 answer
Excel vba protect worksheet without password
VBA
0 vote242 views1 answer
Vba search string position
VBA
0 vote245 views1 answer
Vbscript check if string contains
VBA
1 vote163 views1 answer
Ms access open form to new record
VBA
0 vote226 views1 answer
Vba horizontalalignment
VBA
0 vote287 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote228 views1 answer
Excel vba formatconditions range
VBA
1 vote223 views1 answer
Excel date to unix timestamp
VBA