I just discovered that I don?t understand what ?Application.ScreenUpdating = False? does.
When I executed the following macro:
[vba]Sub TestScreenUpdating
Range(?A1?) = ??
Application.ScreenUpdating = False
Range(?A1?) = ?ABC?
Stop
End Sub[/vba]
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???
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Didn't you get an error on stop?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
No error occurred . . . what did I do to cause an error??
Posting Permissions
Reply With Quote
