Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Force charts to refresh? | Charts and Charting in Excel | |||
Excel Screen Refresh Issue in Terminal Server | Excel Discussion (Misc queries) | |||
force numbers as text as seen on screen | Excel Discussion (Misc queries) | |||
supress screen refresh when macros running in excel VB | Excel Programming | |||
Force refresh of custom functions | Excel Worksheet Functions |