Application.ScreenUpdating = True Doesn't Work

[JStellato]

<code>I have a strange problem, forever when I ran my code, the screen flashed. I found this line that turns off the flashing
</code><code>

</code><code>Application.[B]ScreenUpdating[/B] = False

That code worked perfectly, the screen no longer flashes, however, if I comment out that line and put in

</code><code>

</code><code>Application.[B]ScreenUpdating[/B] = True

</code><code> as the first line in the code, the screen still no longer refreshes like it once did before.

Is this something that once it's disabled it never comes back? I'm using Excel 2010. I actually want the screen to flash in this situation,

Thanks</code><code></code></pre>

 

[Michael M]

In the VBA Editor press CTRL + G and copy the line of code into the immdiates pane and press Enter
That should turn it back on !