Gary Brown wrote:


The problem is:
Every so often, the Class Module stops working and the status bar no
longer updates. I can't pin down what's going on when it stops
working because I only look at the status bar when I need the
sum/count information.and then notice that it's not giving me the
information. I have another Class Module that also depends on
specific events such as SheetActivate that also appears to stop
working at the same time.

Do you have another routine that you run occasionally that features an End
statement? This would kill the global variable that is holding the instance
of your class, even if it happens in a completely unconnected project. End
is evil. Don't use it folks.

Rob