Regarding the suggestion by Tom Ogilvy below, let's say that I have ten
columns with filters but only two of them are On,
with criteria. I can loop through the filters to see which ones are on
and get the criteria, but how do I 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.

So my question remains, how can a return the column number or address of the
column being filtered

"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