refresh of screen -- commando

[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

 

[Chip Pearson]

Mat,

Use something like

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

 

[Amit Shanker]

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

Amit