/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

6 votes254 views1 answer
Excel vba isalpha
VBA
0 vote230 views1 answer
Excel vba cell on change
VBA
0 vote213 views1 answer
Excel vba show developer tab
VBA
0 vote233 views1 answer
Vb streamreader
VBA
0 vote233 views1 answer
Dlete rows with blanks and space " " vba
VBA
3 votes259 views2 answers
Vba active workbook path
VBA
0 vote236 views1 answer
Vba option button selected
VBA
0 vote222 views1 answer
Vba parameter adodb null value
VBA
1 vote216 views2 answers
Get all column names from excel vba
VBA
0 vote233 views1 answer
Openfiledialog specific folder
VBA