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
Application.Calculation = xlCalculationManual
at the end of the script, you should put this lines:
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.Calculation = xlCalculationAutomatic
No comments:
Post a Comment