auto-filter change not triggering worksheet_change event

[mark]

Hi.

I have some code which I would like to have run each time
that the selection criteria are changed in an auto-
filtered table.

The code itself is working fine, but the trigger is not.
I tied it to the sheet's code, and asked it to run with
the Worksheet_Change event... but it's not triggering
unless I actually go in and change a value.

I had had it tied to the Worksheet_SelectionChange . It
didn't trigger then either... unless I went in and changed
cells. That made some sense, which is why I changed it to
the worksheet_change event.

Changing the criteria in an auto-filter isn't seen as a
worksheet_change?

Does anyone have a suggestion as to how to trigger the
code this way, or a better way?

Thanks.
Mark

 

[mark]

Then I used a Worksheet_Calculate event

Thanks... that's what I discovered yesterday, basically..
I put a subtotal formula at the bottom of one of the auto-
filtered columns, and then used the Calculate event... as
you say.

I just hadn't posted that because I still wanted to see if
anyone else might have a better idea.

Thanks!