Determine which column is filtered

[wv1]

Hi All
Is it possible to determine which column (1-8) has an autofilter currently ON within it?

i.e. If i have columns name, age, school and I have filtered on Column 3 to show only a certain school, is there anyway in a macro that can return to the user which column they currently have a filter on?

Many thanks

 

[dallen43]

In my Excel (2003), the column(s) that are filtered has a blue drop down arrow, while the column(s) that are not filtered are black.

 

[xlbo]

You will need to iterate through the Filters collection to obtain this info. There is some pretty good example code in the VBA helpfiles on this. Please have a look there and post back if you have any specific problems with the examples given there.

a VBA helpfile search on "Filter" or "Autofilter" should give you the appropriate results - choose the "filters collection" heading to get further details

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question