How can one discern what column is being referenced when a filter is on?
For example, ActiveSheet.AutoFilter.Filters(1) might refer to what COLUMN
or RANGE when .On is true?

Thanks for your help.

BT in MN

T.O.:

Let's say that I have ten columns with filters but only two of them are On,
with a criteria. I can loop through the filters to see which ones are on
and get the criteria, but I do not have a way to determine which column it
is that has the filter on. Your code returns the first column in the range
being filtered but doesn't help identify where the filters are that are on.

Make sense?


"Tom Ogilvy" wrote in message
...
activesheet.Autofilter.Range.columns(1).Column

the filter count doesn't change.

--
Regards,
Tom Ogilvy


"BTuohy" wrote:

How can one discern what column is being referenced when a filter is on?
For example, ActiveSheet.AutoFilter.Filters(1) might refer to what
COLUMN
or RANGE when .On is true?

Thanks for your help.

BT in MN

You picked the example. I showed you how to extend your example.

Use the same counter to identify the column.

Make Sense?

If you look at the code Dave has posted, you will see how that is done in
the first example.

--
Regards,
Tom Ogilvy




"BTuohy" wrote in message
...
T.O.:

Let's say that I have ten columns with filters but only two of them are
On, with a criteria. I can loop through the filters to see which ones are
on and get the criteria, but I do not have a way to determine which column
it is that has the filter on. Your code returns the first column in the
range being filtered but doesn't help identify where the filters are that
are on.

Make sense?


"Tom Ogilvy" wrote in message
...
activesheet.Autofilter.Range.columns(1).Column

the filter count doesn't change.

--
Regards,
Tom Ogilvy


"BTuohy" wrote:

How can one discern what column is being referenced when a filter is on?
For example, ActiveSheet.AutoFilter.Filters(1) might refer to what
COLUMN
or RANGE when .On is true?

Thanks for your help.

BT in MN