ScreenRefresh

Syntax

ScreenRefresh

Remarks

Updates the display on your monitor to show the current screen display. You can use ScreenRefresh in a macro after a ScreenUpdating instruction has turned off screen updating. ScreenRefresh turns on screen updating for just one instruction and then immediately turns it off. Subsequent instructions do not update the screen until screen updating is turned on again with another ScreenUpdating instruction. You can use ScreenRefresh and ScreenUpdating to create a series of screen "snapshots." During a long process, the screen can be updated from time to time to indicate the macro's progress.

Note

On the Macintosh, document windows are hidden when screen updating is turned off. A ScreenRefresh instruction displays updated document windows for an instant, but then the document windows are hidden again. Therefore, on the Macintosh, you may want to use ScreenUpdating instead of ScreenRefresh to turn screen updating on and off.

For an example, see ScreenUpdating.

See Also

ScreenUpdating