Monday, November 12, 2007

Speed up vba

Hi again.

a small hint for vba users. if you move large amount of data and your script takes too long to run, consider putting the following lines at the beginning of the script:

Application.ScreenUpdating = False

Application.Calculation = xlCalculationManual


at the end of the script, you should put this lines:
Application.ScreenUpdating = True

Application.Calculation = xlCalculationAutomatic

No comments: