How To Use Variable Scope and Variable Lifetime In Excel
Oct 21, 2020
Sometimes you want to retain the value of a variable in Excel VBA when a procedure ends.
How To Use Option Explicit In Excel
Oct 18, 2020
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.
Variables and Variable Scope In Excel VBA
Oct 16, 2020
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.