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:
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: