Hi
You just type DoEvents on a new line. It forces Excel to update the
screen (amongst other things) before proceeding with the next line of
code. You can put it into a block of code more than once, especially
after code that updates the screen. I have sometimes had to use
DoEvents
DoEvents

as it seems to make things update better than one such line - heaven
knows why!
regards
Paul

On Apr 1, 2:55*pm, Fan924 wrote:
Application.Screenupdating = False

This is the first thing I tried. Not any better.
Could you give an example of DoEvents. I am not familiar with it.
Thanks Paul