I thank you both and apologize for not posting the code in the correct fashion (using tags).

I have just tried the first suggestion and it worked! I am afraid I do not fully understand VBA so I am not sure why it worked but I am very happy.

I also looked at the second suggestion but have not tried it yet. However, looking up the error message earlier today I understood it was about not having the proper reference to the sheet so I am pretty sure it will work as well.

Thanks a lot again!