I am facing an issue with MS Excel 2013. I am facing flickering issues when copying data from one sheet to another.Whenever I type Application.ScreenUpdating = False in the background code, it doesn't work and when checked in the immediate window, it shows
Application.ScreenUpdating=True. What can be the alternate code for it. Plus, I would also like to know how to record a macro to stop screen flickering in the same version of excel
In Excel, turn screen updating off can speed up the macro code. We are unable to see what the macro is doing, but it will run faster. Besides, we need to set the ScreenUpdating property back to True when your macro ends. For the example, please
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.