Thread: Reduce Flashing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
 
Posts: 137
Default Reduce Flashing

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.