_Application.ScreenUpdating Property
True if screen updating is turned on.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property ScreenUpdating As Boolean
Get
Set
'Usage
Dim instance As _Application
Dim value As Boolean
value = instance.ScreenUpdating
instance.ScreenUpdating = value
bool ScreenUpdating { get; set; }
Property Value
Type: System.Boolean
Remarks
Turn screen updating off to speed up your code. You won't be able to see what the code is doing, but it will run faster.
Remember to set the ScreenUpdating property back to True when your code ends.