View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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