/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

8 votes232 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote228 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote229 views1 answer
Vba first cell in range
VBA
0 vote210 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote218 views1 answer
Check range is in another range vba
VBA
0 vote227 views1 answer
Vba check 32 or 64 bit
VBA
0 vote236 views1 answer
Group controls programmatically vb
VBA
0 vote248 views1 answer
How to enter Vbox manage commands
VBA
0 vote228 views1 answer
Dynamic array vba
VBA
0 vote243 views1 answer
Test if form is open vb
VBA