Thank you J that does seem more straight forward and thank you for catching the errors. However when I implemented the code you suggested I receive a Run Time Error '438' Object doesn't support this property or method.

When debugging it highlights the first row that identifies the destination and source. Any thoughts?