18 April 2015
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, module level, and public module level.
This article describes VBA variable scope, including examples.
Full article: Variable scope in Excel VBA
