Insert Rows causing screen flicker RRS feed

  • Question

  • Hi all

    I have a For loop that inserts a row 22 times in a Worksheet. I set Application.ScreenUpdating = False, but I still get a blank white screen flash with each insert. Any suggestions how I can stop the screen updating?


    Thursday, May 30, 2019 2:47 PM

All replies

  • Paul,

    If you run code from the module, screenupdating is always on.

    If that is not the case, there is the use of the "LockWindowUpdate" API function call.
    I've only used it on 32 bit systems and never on Windows 10.
    It completely freezes the Window and the window stays that way unless properly released.
    If problems occur then Windows must be shut down and restarted.
    Use only if you are desperate.

    Thursday, May 30, 2019 9:44 PM
  • Hi Paul,

    Do you have a For Loop where inserting one row 22 times?
    If so, I'm afraid you should do insert 22 rows only once with out a For Loop.


    Ashidacchi --

    Thursday, May 30, 2019 11:35 PM
  • NLTL, I don't understand "If you run code from the module, screenupdating is always on". I use Application.ScreenUpdating=False to turn off screen updating. It generally works, but isn't working in my scenario.
    Friday, May 31, 2019 8:49 AM
  • Ashidacchi, your answer isn't relevant to my question.
    Friday, May 31, 2019 8:50 AM
  • Can you share your code?

    And how do you run your code when you notice the flickering of the screen?

    Subodh Tiwari (Neeraj) sktneer

    Friday, May 31, 2019 9:23 AM