Hi Sam,

I do not think that any events are directly
triggered changes in an Autofilter's criteria.

The conventional aprroach would be to use
Excel's SubTotal formula (see below) in a
suitable location on the worksheet; the
Worksheet_Calculate event would then be
fired by a change in the value returned by the
formula, which wuld result from a change to
the autofilter criteria.

The relevant formula might be something like:

Application.WorksheetFunction.Subtotal(2, Range("A2:A1000"))



---
Regards.
Norman


"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:848b08e9b864e@uwe...
Hi All,

I would like to trigger a calculation of the active worksheet when a
specific
AutoFilter Field is selected and any criteria / item is filtered or reset
to
AutoFilter All. Can anyone provide the relevant VBA code and advise where
it
should be placed?

Thanks,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200805/1