/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 vote175 views1 answer
Excel vba saveas no prompt for overwrite
VBA
4 votes191 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote186 views1 answer
Vba extract filename from path
VBA
0 vote163 views1 answer
Excel vba disable screen update
VBA
0 vote182 views1 answer
Vba horizontalalignment
VBA
0 vote170 views1 answer
Excel vba disable alerts
VBA
5 votes191 views1 answer
Excel vba tool to help with refactoring code
VBA
1 vote199 views1 answer
Perform http request in vb.net
VBA
0 vote171 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote185 views2 answers
Excel vba password protect
VBA