|Posted: December 13, 2007, 7:09 pm - IP Logged|
When I'm running code, if I switch to some other task (surfing, writing, whatever), sometimes excel will turn off screen updating (that's where you can see the macro progress as it changes cell contents). That means that the spreadsheet is "frozen" until the macro completes.
I don't see in any of the menu options where it can be "forced" on. Maybe I missed it? I have even set up a loop to periodically set screen updating equal to TRUE, but this has not helped.
Anyone else run into this? I want to be able to peep in on the progress, as it runs.
(Yes, I know it runs faster with screen updating = FALSE.)
(Maybe this should be called the Math & Coding Forum)
In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.