Filter change triggers event?

[ckiraly]

This may seem really dumb, but is there an event that gets triggered after an AutoFilter changes? If not, is there a way I can make one?

[mikerickson]

If any cell on the sheet contains a formula that refereces any cell in the filter range, changing the filter triggers a Worksheet_Calculate event.

If not, putting =A2 (or some other cell in the filter range) in some out of the way cell seems the easiest way to make a "AutoFilter_Change" routine.

[ckiraly]

Awesome! Thanks!