View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ming Ming is offline
external usenet poster
 
Posts: 5
Default Force Excel to Refresh Screen

I have a macro which goes through a "for loop" for a large number of
loops and it takes several hours to finish running. I output the number
the run has gone up to in the status bar to show the progress.

Whenever I click away from Excel to another application or when the
screensaver kicks in and I move the mouse again, I get a white screen
in Excel which I can see neither the worksheet nor the status bar. I am
not turning off screen updating in my code.

Does anybody know whether there is a way to get Excel to refresh the
screen (or at least the status bar) during an intensive calculation?