application screen updating

[freshfruit]

What is application screen updating and why should I use it? I'm sure you guys will be over this one because it's easy, but how about you help me with my other more complicated posts!!?? please

Should I keep screenupdating on when I'm learning by testing code?

[daffodil11]

Application Screen Updating is worth turning off (in my opinion) for any operation that exceeds more than a few dozen actions. Otherwise, you're left to watch as Excel jumps around, fills in cells, selects tabs, and does one thing at a time. If a macro I write is for someone else to use, I always turn it off regardless of the volume of actions.

I generally add it as a last step when a macro I've been working on has been tried and tested. It's nice to still see what's going on while you're debugging your code, so you can interpret where the breakdown is, if a sheet didn't get selected and maybe it should have, etc.

[Izandol]

If you are stepping through code to debug, screenupdating will always be on even if your code turns it off.

[daffodil11]

I meant more along the lines of when the code executes without errors, but not in the way how you wanted.