A collection of 4 posts

How To Use Option Explicit In Excel

We strongly recommend to use Option Explicit at the start of your Excel VBA code. Using Option Explicit forces you to declare all your variables. For example, place a command button on your
18 October 2020

Variables and Variable Scope In Excel VBA

The scope of a variable in Excel VBA determines where that variable may be used. You determine the scope of a variable when you declare it. There are three scoping levels: procedure level,
16 October 2020