7 common VBA mistakes to avoid

7 common VBA mistakes to avoid

21 September 2017

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.