Macro question

[lolatu2]

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?

 

[NARAYANK991]

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

 

[lolatu2]

Thank you!!

 

[SirJB7]

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!