TBA,

Precede it by

Application.DisplayAlerts = False

reset it afterwards if there is more code, and not the end of the sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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