Good point, and it also reminded me to look on my status bar page where I found
the link the MS KB article about calculate.
http://www.mvps.org/dmcritchie/excel/statusbar.htm
The Calculate message may remain in the status bar when you enter formulas that include cell references
"This behavior occurs when there are 65,536 or more dependencies to unique references (the level or number of links between
formulas). "
http://support.microsoft.com/default.aspx?scid=243495
I hope John provides feedback whether he finds a solution or not.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"bigwheel" wrote ..
Use Application.StatusBar = ""
"John Tripp" wrote:
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