I have now completed the code revisions and everything is working well. I have checked through again and can confirm that if the .Copy (table1 row) is placed before the .Add (table2 row) that the buffer is cleared causing the .PasteSpecial to fail. As you said it would seem this is a bug as there is no logical reason for such an action. Thanks again for your help.