Sometimes you want to retain the value of a variable in Excel VBA when a procedure ends.

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.

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.