We define performance as how fast your add-in runs. The broad idea underlying most performance tips is not to make the VBA engine work any harder than necessary. The less work VBA has to do, the faster it runs.
For instance, you can think of each line of code in your add-in as a step that needs to be completed by VBA when it runs your add-in. If you reduce the total lines of code in your add-in, you generally require VBA to take fewer steps and therefore allow it to run your add-in more quickly. The following are some tips on how to increase the speed of your code.