Determining if User Filters a List

[PosseJohn]

I would like to be able to detect when a user filters the list on my worksheet that resides in range A15:I500, and then perform some automated actions.

Is this 'detection' possible?

Thank you.

[Oppressed1]

One thing you might use is to test
ws.AutoFilter is nothing
where ws is Activesheet (or any worksheet).

With ws.AutoFilter
then
.Range.Address is the filtered range

More ways you can browse what's being filtered:
Dim filterArray() 'variant, so can be redimmed
and go

Please Login or Register  to view this content.

and so forth. You could test intersection with your desired range.

Is any of this of interest?