Whenever you make a macro that not only calculates but filters and formats the data, and also when there麓s a lot of data, excel shows the cells as they are filled with information. Moreover, when some kind of format is put to the cells, the format menu botons are pressed too.
I can't help to think that the motion showed takes away a lot of computing speed. So I wanted to know how to deactivate that motion, so that i will just see the end result, and none of the intermediate motion.How to deactivate the motion produced by macros in Excel?put this at top of your code (just below the Sub ***() line)
Application.ScreenUpdating = False
If you put the above line of code in, BE SURE to put this just above the End Sub line:
Application.ScreenUpdating = TrueHow to deactivate the motion produced by macros in Excel?Best answer goes to The LB.
However, it is not necessary to reset Application.ScreenUpdating to True. It automatically resets to its default value of True at the end of any procedure in which it has been set to False.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment