View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Amit Shanker Amit Shanker is offline
external usenet poster
 
Posts: 25
Default 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