Basic rules of VBA programming in Excel

[Admin]

Please reply to this post with any comments on the article Basic rules of VBA programming in Excel.

[Robert]

5.Always use Option Explicit
Why? First, if you do not use Option Explicit and misspell a variable, VBA will treat it as a new variable having a value of zero and won't through an error. And this error will be hard to find! Second, Option Explicit encourages you to think of proper types for variables, rather than just using Variant, which is often inefficient.

I think that you mean throw instead of through. This should be an easy fix.

[Support]

Yes, indeed! Thanks! And it also shows why Option Explicit is important: it's easy to misspell things!