Is there a way in VBA to count the number of columns holding the filter symbol?
I currently have a Reset macro to remove all filters in one go:
and cycle through this a fixed number of times. Some of my sheets may only have 4 columns filtered and some could have as much as 18 (although the're not all aplied at once).
It would be helpful to know one way or the other if this is possible.
Thanks in advance.
I currently have a Reset macro to remove all filters in one go:
Code:
Selection.AutoFilter Field:= i
It would be helpful to know one way or the other if this is possible.
Thanks in advance.