/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

2 votes297 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote272 views1 answer
Vba exit while
VBA
1 vote289 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
22 votes405 views1 answer
Xlvba check for folder
VBA
0 vote302 views1 answer
Excel vba copy range with filter
VBA
0 vote372 views1 answer
Vba vbcrlf chr
VBA
0 vote276 views1 answer
Refresh token em vb net
VBA
0 vote281 views1 answer
Get current url vb.net
VBA
0 vote290 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote278 views1 answer
Vbnet check if number is even or odd
VBA