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" <(E-Mail Removed)> wrote in message
news:A5597C5F-251A-452C-9114-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:A5597C5F-251A-452C-9114-(E-Mail Removed)...
>> 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
>>>
>>>
>>>
>
>