/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 vote150 views1 answer
Vba add shape oval
VBA
12 votes292 views1 answer
Excel vba write string to text file
VBA
8 votes211 views1 answer
Excel vba make word
VBA
0 vote159 views1 answer
Check range is in another range vba
VBA
3 votes164 views1 answer
Excel insert blank row for value change in column
VBA
0 vote171 views1 answer
Vba dictionary length
VBA
8 votes168 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote169 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote155 views1 answer
Vb window.minimize
VBA
0 vote162 views1 answer
Xlbycolumns is not declared
VBA