First, macropod (Paul Edstein) is a far better and more experienced coder than am I and will probably be answering here. He is a busy man, though.
It occurs to me that you might want
before
Code:
Application.ScreenUpdating=True
Note, I have not tried this but it should not hurt.