Excel VBA Option Explicit to force declaration of variables

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