• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro question

lolatu2

New Member
How do you freeze the view so that when a macro runs, the program doesn't slow down to move the view to different sheets?
 
Hi ,


Include the following statement at the beginning of your macro :


Application.ScreenUpdating = FALSE


and reset it to :


Application.ScreenUpdating = TRUE


before the macro exit.


Narayan
 
Hi, lolatu2!


Agreeing with NARAYANK991 I'd add my two cents:

a) if not needed avoid automatic calculation:

Application.Calculation = xlCalculationManual

Application.Calculation = xlCalculationAutomatic

b) avoid using unnecessary .Select instructions:

many standard or recorded macro codes use them and after use Selection.whatsoever; this reduces processing speed dramatically


Regards!
 
Back
Top