![]() ![]() Avoid 'Screen Flickering' or 'Screen Repainting': UseĪpplication.ScreenUpdating = False 'To Turn Off at the start of code.Īpplication.ScreenUpdating = False 'To Turn on at the end of the code. ![]() ![]() So streamline your program logic and get the best performance of macros. Without a good logic, a good written VBA macro program has no value. Analyze the logic: Before optimizing the syntax, pay more attention in optimizing the logic. Use Worksheet Functions wherever applicable Do read full article to understand the logic behind them. Use 'Early Binding' rather 'Late Binding' 16. ![]() Reduce the number of lines using colon(:) 10. Wish my readers a very MerRy ChRisTMaS !ġ. Read them carefully and open new pathways of innovation in creating excel dashboards, reports and automation. VBA programs are known to save a lot of time and now this post is to save further time. It contains both the knowledge and good practices which if followed and used effectively then it might put you in elite category of excellent VBA programmers. On the eve before Christmas, I'm writing this article on VBA code optimization for my blog readers as a gift. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |