7 common VBA mistakes to avoid

When it comes to VBA, it's almost too easy to make a mistake. These mistakes can cost you greatly, both in time and in frustration.

In this post, I'd like to help you avoid these typical mistakes and make you a better VBA programmer:

• Using .Select / .Activate.
• Using the Variant type.
• Not using Application.ScreenUpdating = False.
• Referencing the worksheet name with a string.
• Not fully qualifying your range references.
• Making your Sub / Function TOO LONG.
• Going down the nested For / If rabbit hole.