Thanks for the feedback cplettner. I do apologize for not adding the code tags, this is my first post to excelforum. I've just recently learned some of the basics in VBA coding in excel, and I think I get easily carried away with applying basic techniques when other techniques would serve me better. I really appreciate you adding to the code and I will try your modifications to clean it up and see if it resolves the error I was getting. Just for my understanding of the Run-time error '9', was there something specifically in my code that caused this?

Thanks again for the help.