Hi Ford,

Is all your above code behind a sheet or in a Module? This might help understand why it is important.
http://www.cpearson.com/excel/Scope.aspx

Here might be some more help with your VBA Ranges.
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm