refresh of screen -- commando
 

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

refresh of screen -- commando
 

Mat,

Use something like

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




"matthias" wrote in message
...
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

refresh of screen -- commando
 

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

Amit


"matthias" wrote in message
...
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