Vba screenupdating false
Example This example demonstrates how turning off screen updating can make your code run faster.The example hides every other column on Sheet1, while keeping track of the time it takes to do so.
Vba screenupdating false who is frank langella dating now
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Remarks Turn screen updating off to speed up your macro code.
Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately.
Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application.
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.