When you are writing code and you are testing the process, to mack sure the process works you normally watch the process on the screen, for instance if you have a series of data in your columns and you want to scroll down each line and do some kind of validation this is what you will see on the screen. However this process can be slow. To speed things up in terms of processing you switch off the screen updating i.e. application.screenupdating = false, then run the process you wont see anything happening on screen but at the end of the code you must conclude with application.screenupdating = true to ensure things go back to normality.
Hope that is helpful
cheers
Matt
|
Application.ScreenUpdating = True
