/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 vote136 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote131 views1 answer
Vba declare 64-bit ptrsafe
VBA
27 votes254 views2 answers
Vba check if file exists
VBA
0 vote125 views1 answer
Vba code to select image in sheet
VBA
0 vote145 views1 answer
VBA Sort RossetaCode
VBA
0 vote128 views1 answer
Vbscript remove spaces from string
VBA
0 vote125 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote142 views1 answer
How to add line graph vb net
VBA
0 vote86 views10 answers
Vba excel create event log
VBA
1 vote128 views1 answer
Excel vba last column in range
VBA