Screen blanks while macro executes

  • I have an occasional problem when executing long-running macros. Sometimes, and there is no consistency to it, the Excel window blanks out entirely, just showing a white screen, till the macro completes. Next time it works fine, the next time it happens at a different time, etc.


    I have screen updating turned off during the execution of the macro, but I do have it turn on and then off again at times to show the interim results.


    Any ideas what is happening here, and how to prevent it?

  • Re: Screen blanks while macro executes


    memory?

    I wouldn't use screenupdating on/off to display interim results. What is the purpose of showing these interim results? (as in there may be a better solution to what you are trying to achieve)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!