Thread: Reduce Flashing
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Reduce Flashing

Yes, that I meant, not .DisplayAlerts.
Don't know where taht came from.

NickHK

"Greg Glynn"
egroups.com...
Another thing to try is putting

Application.Screenupdating = True
Application.Screenupdating = False

... pairs of code-lines at the places in your process that you want to
see what has been updated. It has the effect of redrawing the screen
and then freezing it again.