Hi yossel and welcome to the forum,

Here is the best explanation about scope I've found.
http://www.cpearson.com/Excel/Scope.aspx