Marvin,

I see your point and yes, you are correct. I am self taught and make a lot of simple errors like this.

However, as I run the code in a module, it breaks down when I am setting my variable. For example everything looks good in my watch window until I try to set my "advert" variable. I get an object required run-time error. What troubles me is this method executes in other modules just fine and I don't know why the object would change when I am setting the variables. Any ideas?

Thank you for your time. Now I will be more mindful to place my code in modules where they belong.