Wednesday, 11 July 2012

How to Speed Up the macro performance / Improve efficiency of macro


How to Speed Up the macro performance / Improve efficiency of macro ?

How to stop blinking Excel while running a macro ?


You can see magic on your macro if you add the below line just after starting of your code.

Application.ScreenUpdating = False

By default, this setting will be 'True' mode.

Then, Excel will update the screen for each task. (Eg : copy paste, delete, filter, etc...)

Macro running speed is very fast, but the screen updation speed is very low.

So it will end up in annoying blinking of excel and it affects macro performance very badly.

If you disable the screen updation, macro will run smoothly and Excel will hide all the screen updations.

I bet, The speed will make you suprised.....


Note : When the macro finishes running, this setting will automatically change to TRUE. However ever it's a good practice adding a line before end of the sub to the Make this setting TRUE.