by
12k 31
0
7
5,977
3
Top 1% !
Popular
Famous
Pearl of Wisdom
Tagged
Specified
OpenSource
Popularity: 1220th place
Created
Modified Nov 12, 2014

Published on:

Architecturex86_64
LanguageVBA
LicenseMIT_X11
OSWindows
Windows VersionWindows8

Screen update disable in Excel VBA

How to disable and enable screen update in Excel VBA, speeding up macro execution
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/11289/Screen-update-disable-in-Excel-VBA?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
' disable screen updating Application.ScreenUpdating = False ' enable screen updating Application.ScreenUpdating = True
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus