Paste Method Failure when copying between worksheets

Hi Everyone

I am trying to copy a row from one table to another on 2 seperate worksheets.

First I copy the row then create a new row in the second table. All of that works fine. However, when I actually try to paste in the new location, I get a "Paste Method of Worksheet Class Failed message" when I try to run the following code:

Please Login or Register  to view this content.

Any help is appreciated.

Thanks,
Jim

Thanks Norie. Different approach. I like it better. More clean. Problem solved.