View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Clearing the status line

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