/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

4 votes276 views1 answer
Vba create directory
VBA
0 vote303 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote315 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote286 views1 answer
Vba is integer
VBA
0 vote286 views1 answer
Vba listbox remove all items
VBA
0 vote269 views1 answer
VB Error Code BC30201
VBA
0 vote280 views2 answers
Get excel file from email attachment in vba
VBA
0 vote279 views1 answer
Search combobox items vb.net
VBA
1 vote304 views1 answer
Excel vba get column number from column name
VBA
1 vote310 views1 answer
Excel vba convert text YYYYMMDD to date
VBA