Loop through columns determine if autofiltered

[randell.graybill]

I am having difficulty with this one. i have 13 columns that have the possibility of being filtered. What I want to do is check each column for a filter and then remove the column arrow if it is not filtered...alternatively can I remove the filter arrow without removing the filter?

[MarvinP]

Hey randell,

It seems to me that TABLES are filtered. A table is defined by a block of cells with no blank row or column in the middle of the cells. If your 13 columns are in the table and the table filter is turned on (the cells are treated as a table) then they are all available to be filtered.

[randell.graybill]

Thank you for taking the time to respond, however I am not any closer to understanding how to solve my problem. the end goal would be to turn off all filter arrows but still retain the filters is this possible?

[MarvinP]

Have you looked at using an Advanced Filter (in place)? I believe it won't show the top arrows but will hide the rows that don't match the filter criteria.

http://www.contextures.com/xladvfilter01.html

[Trebor76]

the end goal would be to turn off all filter arrows but still retain the filters is this possible?

No, the two are mutually exclusive.

You can check if a filter exists and if so capture it's settings, then turn it off, run your code and the reapply the filter settings using a custom view like so:

Please Login or Register  to view this content.

HTH

Robert