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!
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!
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.