Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
If I have an Excel Table, and want to check if Autofilter is applied (to the Table), how do I go about it?
I have tried:
which errors out if Autofilter isn't applied.
I have also tried:
But this returns False if it is a Table.
I could turn off error reporting to avoid the code bugging out but I assume there is some other way I have missed?
Thanks for any help
I have tried:
Code:
If Activesheet.ListObjects(1).Autofilter.FilterMode Then ...
which errors out if Autofilter isn't applied.
I have also tried:
Code:
If Activesheet.AutofilterMode Then ...
But this returns False if it is a Table.
I could turn off error reporting to avoid the code bugging out but I assume there is some other way I have missed?
Thanks for any help