Cross-posted at:
vba - Copy row and paste to new table - Stack Overflow
For cross-posting etiquette, please read:
A message to forum cross posters - Excelguru
Also, when posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.