/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 vote358 views1 answer
Vba option button selected
VBA
0 vote365 views1 answer
Vbs expand env var
VBA
1 vote359 views1 answer
Add control vb
VBA
4 votes366 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
5 votes381 views1 answer
Excel formula how to create strings containing double quotes
VBA
15 votes510 views1 answer
Excel vba wait
VBA
0 vote357 views1 answer
Vba horizontalalignment
VBA
0 vote363 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote370 views1 answer
Vba static variable
VBA
5 votes424 views1 answer
Excel vba last byte from INTEGER
VBA