/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

3 votes178 views2 answers
Vba date to string
VBA
0 vote151 views1 answer
Vba full date format
VBA
4 votes161 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote136 views1 answer
Remove frist letter from string vbnet
VBA
0 vote156 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote150 views1 answer
Excel vba first and last row and column in range
VBA
0 vote149 views1 answer
Vba compare strings
VBA
0 vote178 views1 answer
Wpf dark title bar
VBA
1 vote138 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote156 views1 answer
Vba exit while
VBA