/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 vote215 views1 answer
Sort dictionary by key vba
VBA
4 votes213 views1 answer
Vba create directory
VBA
1 vote237 views1 answer
Vb.net get name by Cell Click
VBA
0 vote207 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
1 vote221 views1 answer
Excel vba array remove first
VBA
0 vote207 views1 answer
WGET FTP
VBA
1 vote218 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote226 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote206 views1 answer
Excel vba range contains
VBA
0 vote210 views1 answer
Excel vba copy entire sheet paste values
VBA