Missing "Option Explicit"




CrunchCode presupposes the syntax of the source–code is correct. THE SYNTAX IS NOT CHECKED!

In particular, the declaration and use of variable names must be UNAMBIGUOUS.

The statement "Option Explicit" forces you to define all variables before their use (e.g. "Dim" statement).
This avoids misspelled names or the multiple use of existing names
as well as avoiding confusion in the code with unclear scope of variables.

This guarantees a consistent use for all variables.

Modules are therefore only processed if they include "Option Explicit".

Note:
In the VBA Editor, the menu "Extras –> Options –> Editor –> variable declaration required"
automatically inserts "Option Explicit" in each new VBA module.