Vb6 screen updating
You can verify this by launching Word the old-fashioned way and opening File1 at the bottom of the File menu after running the sample code.
Keep that on mind if you will execute anything which would take less time.
And after all don’t turn screen updating on/off many times in some loop. And one more note (which you probably don’t want to hear) if you want it quick use C .
It is typically 5 to 10 times quicker (don’t catch me here it depends on what you really do) than VBA.
This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.
You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.