Laufzeitfehler 91
05.11.2022 10:27:40
Chris
Objektvariable oder With-Blockvariable nicht festgelegt. Was kann ich dagegen tun?
Vielen Dank
Chris
Private Sub Filter()
Dim myTable As ListObject
Dim mySheet As Worksheet
For Each mySheet In Worksheets
For Each myTable In mySheet.ListObjects
myTable.AutoFilter.ShowAllData
myTable.ShowAutoFilterDropDown = False
Next myTable
Next mySheet
End Sub