Hey John, Welcome to VBAX

Take a look at OZGrid's article on Variable Scope:
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm

It uses Excel as its example, but the concept still holds for all VBA variables (that I know of )

Good luck!