EXCEL VBA Questions and Answers

What is the meaning of Option Explicit and Option Base?

Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. For eg. Option Base 1 will make the array lower bound as 1 instead of 0.