Screen Updates


Posted by mark on March 26, 2001 7:29 AM

I have a macro that writes some information that is stored in a text file but, when the macro runs the screen flashes updates. and I know it is a simple line of code needed but cannot remember how to turn of the screen updates. Can someone solve my little dilemma.

Posted by mseyf on March 26, 2001 7:54 AM

Application.ScreenUpdating = False



Posted by Mark on March 26, 2001 8:14 AM

Cheers..... I knew it was something simple.