PDA

View Full Version : Regarding Application.ScreenUpdating=False



Cyberdude
09-25-2008, 03:50 PM
I just discovered that I don?t understand what ?Application.ScreenUpdating = False? does.

When I executed the following macro:
Sub TestScreenUpdating
Range(?A1?) = ??
Application.ScreenUpdating = False
Range(?A1?) = ?ABC?
Stop
End Sub
then looked at cell ?A1?, I saw ?ABC?. Since I stopped the execution of the macro (i.e., it was still active), shouldn?t I see a blank in ?A1??? :bug:

lucas
09-25-2008, 04:45 PM
It just keeps the screen from flickering back and forth between actions that might be in different locations on the sheet. Has nothing to do with the rest of the code.

lucas
09-25-2008, 04:50 PM
Didn't you get an error on stop?

Cyberdude
09-25-2008, 04:54 PM
No error occurred . . . what did I do to cause an error??