Kevin,

You could use a cell with a SUBTOTAL formula call to the filtered range and the worksheet's
calculate event will then fire when the autofilter is changed.

HTH,
Bernie
MS Excel MVP


"Kevin B" wrote in message
...
I have a macro that I want to execute every time an Autofilter is updated in
an Excel workbook, but updating an Autofilter does not trigger the workbook
SheetChange event or the worksheet Change event. Can anyone point me in a
direction I need to look in?


Thanks.

--
Kevin Backmann