I have a workbook with several sheets, some with AutoFilters others without.
If I want to make changes with a macro, those changes are only made to what is visible, not to what is hiden by the filter.
I tryed this:
Dim w As Worksheet
For Each w In Worksheets
If w.FilterMode Then Selection.AutoFilter Field:=1
But it only sets the filter to all on the the sheet where I am when I run the macro, not to all other.
Any ideas to solve this? Thanks,