I have a procedure that runs:
which obviously isn't working because the screen updates a whole lot afterwards.Code:Application.ScreenUpdating = falseI started to debug, and immediately after the "ScreenUpdating = false" line executes, I go to the immediate window and type:
Debug.Print Application.ScreenUpdating
and Excel responds with "True". I know Excel ran "Application.ScreenUpdating = false" because I saw the yellow highlight go over the line in debug mode. Yet, the status of Application.ScreenUpdating remains true.
However, I *can* change the ScreenUpdating from the immediate window. I just can't set it from within a procedure.
Why would this be?![]()




I started to debug, and immediately after the "ScreenUpdating = false" line executes, I go to the immediate window and type:
Reply With Quote