Hi John,

In addition to David's suggestions, it is posssible that your sub turns off
automatic calculation. So, at the bottom of your sub insert the line:

Application.Calculation = xlCalculationAutomatic

---
Regards,
Norman



"John Tripp" <John wrote in message
...
VBA 2000 Excel Office Professional
How can I clear the status line? After I run subroutine the work
"Calculate" appears on the status line. I can't seem to clear it. I
tried
F9. I also tried calculate as last command in macro. Thanks for any help