ScreenUpdating = false: more than once in the same sub()???

Hi Mike,

This little sub should prove that you can turn screenupdating off/on as much as you want.

Please Login or Register  to view this content.

As leith says posts your code and we may be able to help further.

Dear Reafidy and Leith:

Thank you so much for helping me out.
I am trying to copy a live data from one sheet to another and don't like the flickering screen.
As you said, the ScreenUpdate can be turned off/on multiple times (your code is a good way to check the status). Since the screen is still flickering, I went back to check the code and found an error: the final sheet needs to be activated before turning on the ScreenUpdate. Then after the screenupdate is turned on, it needs to be activated again to get the update.
Now it seems fine (still flash a little).
Again, all your help is highly appreciated!

Best,
Mike



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please Login or Register  to view this content.