If you try a simple formula and calculate in all three sheets it calls the
corresponding WorkSheet_Calculate()

May be autofilter is not doing any calculations at all....instead use
Selection change or Change event. If you work with Workbook from sh object
you can get sh.name or sh.index which gives you the worksheet name or index
number


If this post helps click Yes
---------------
Jacob Skaria


" wrote:

Jacob Skaria, Esq

Thank you very much indeed.

Have used ActiveSheet for the "Code-Behind" of Sheet1 & Sheet2.

As it turns out, Sheet2 does not execute the on-board "Code-Behind's
Worksheet_Calculate()" ; it makes use of Sheet1's "Code-Behind".
That's rather Odd indeed.

Have not made use of WorkBook's SheetCalculate().

Other lessons learned are that WorkSheet_Calculate()'s could execute
one after the other for the WorkSheets' Code-Behind.

WorkSheet_Calculate()'s can be rather difficult to handle.

Please continue discussion.

Regards.