Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True

Regards

Trevor


"TBA" wrote in message
...
I know I've seen this tip on this group before, but for the life of me I
can't even begin to think on how to do a Google search for it.

How do I keep my Workbook and Worksheets from flashing and changing as my
code runs? My code is working, but it's terrible on the eyes, makes me
kind
of dizzy. I know there's a simple statement that takes care of this, just
can't remember what it is for the life of me.

Anybody?

Thanks!

-gk