
This tutorial explains how to use Option Explicit to force declaration of variables in Excel VBA (enable Require Variable Declaration)
You may also want to read:
Difference between Dim and Set
Difference between ByRef ByVal
Function, Sub, Method, Property Differences
What is VBA Option Explicit?
Option Explicit is a keyword declared on top of the Visual Basic Editor in the coding Windows outside any Procedures.
In the presence of Option Explicit keyword, all variables must be de...
Read More