Periodic ScreenUpdates

  • I appreciate the help. I have a loop routine in a large spreadsheet that takes a while to run. Mostly due to the size of the worksheet itself but I'm looking for ways to speed it up, like turning the screenupdating = false. However due to the length of the routine (taking anywhere from 15-30mins), I wanted to create a periodic screenupdate. I've placed it inside an If statement nestled in a loop but its not engaging and I don't know why. I should add that if I add a simple msgbox w/ the screenupdate, it'll work as intended.


    Thank you for anyone's time put into trying to help me here.


  • Hi,


    Indeed, you can use the usual instructions :

    Code
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual

    BUT, in my opinion, it would seem the Main issue is a 30-minute macro ...very unusual ...


    I do not know how other Forum members will react, but, would recommend to audit the macro to try to look for core improvements.

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Edited once, last by Carim ().

  • Carim. I understand the 30minute macro is unusual but its not the macro's fault. Its essentially a range of goal seeks and is as simple as macros get. What makes it take so long is the amount of formulas behind the GS iterations (as well as the overall size of the spreadsheet).


    I just thought a screenupdating could shave a few minutes off and would be a simple add.

  • Can you post you complete code

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Here is is JkBox. I appreciate your your time on this.

  • I am pretty certain there is a way of speeding up your code, but need to see your actual file, or a least a truely representitive example of it.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

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