12/8/2014 12:03 PM | |
Posts: 1 Rating:
|
I have encountered a similar problem with Screen Update. I resolved it. I will explain how to handle the screen updates using macro. We can speed up our macro by turning off the screen updating while the macro runs, by adding the below line of code to the macro: Sub Macro () Application.ScreenUpdating = False Write the necessary code Here ——————- ——————- Application.ScreenUpdating = True End Sub. The prior versions of excel 2000, it was not required to turn Screen Updating back to true. When the macro is finished, Excel would revert back to turning the screen updating to true. But now whether you are writing macros in Excel 97, Excel 2000, Excel 2002, 2003, 2007 or 2010 always we have to turn the screen updating back to true with the below code: Application.ScreenUpdating = True
AttachmentHow to Avoid Screen Updating in Excel.pdf (164 Downloads) |
Follow us on