/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

0 vote251 views1 answer
Excel vba unlock sheet without password
VBA
0 vote247 views1 answer
Vba DisplayGridlines
VBA
2 votes232 views1 answer
Vba file from path
VBA
0 vote211 views1 answer
Send webhook vbscript
VBA
0 vote225 views1 answer
How to format a textbox as date vb net
VBA
0 vote225 views1 answer
Windows Forms dark title bar
VBA
0 vote283 views1 answer
Vba is integer
VBA
0 vote227 views1 answer
Write listbox to text file vb.net
VBA
0 vote225 views1 answer
Date as number vb
VBA
4 votes216 views2 answers
Vba array length
VBA