/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

8 votes342 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote202 views1 answer
Vba len variant
VBA
4 votes195 views1 answer
Excel vba check cell not empty
VBA
0 vote234 views1 answer
Excel vba protect sheet
VBA
0 vote228 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote214 views1 answer
Vba simple quote
VBA
0 vote222 views1 answer
Return na vba
VBA
0 vote209 views1 answer
Vba paste values
VBA
0 vote222 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote211 views1 answer
Vba min
VBA