Updates the display on the monitor with the current information in the video memory buffer. You can use this method after using the ScreenUpdating property to disable screen updates.
expression.ScreenRefresh
expression Required. An expression that returns an Application object.
Remarks
ScreenRefresh turns on screen updating for just one instruction and then immediately turns it off. Subsequent instructions don't update the screen until screen updating is turned on again with the ScreenUpdating property.
Example
This example turns off screen updating, opens Test.doc, inserts text, refreshes the screen, and then closes the document (with changes saved).
Dim rngTemp As Range
ScreenUpdating = False
Documents.Open FileName:="C:\DOCS\TEST.DOC"
Set rngTemp = ActiveDocument.Range(Start:=0, End:=0)
rngTemp.InsertBefore "new"
Application.ScreenRefresh
ActiveDocument.Close SaveChanges:=wdSaveChanges
ScreenUpdating = True