refresh of screen -- commando

M

matthias

Hi all,

can anyone give me the commando for

stop & start REFRESHING OF THE SCREEN, so the macro can
run invisible.

txs a lot,

mat
 
C

Chip Pearson

Mat,

Use something like

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True
 
A

Amit Shanker

Application.ScreenUpdating = False 'at start of code
Application.ScreenUpdating = True 'at end of code

Amit
 
Top