You can use the Calculate Event to trap AutoFilter changes. For example:

=SUBTOTAL(2,A:A)

will give the count of visible cells in column A. Excel re-calculates this
whenever the AutoFilter is adjusted and the event gets triggered.
--
Gary''s Student - gsnu200909


"PosseJohn" wrote:

I have a worksheet that has the AutoFilter enabled.

Is there a method to trap when the user selects to perform the AutoFilter?

I want to carry out a few steps when they do.