Copy Range from Worksheet 2, Paste to Next Empty Row Worksheet 1

I know this has been covered extensively already, but I've gone through about 10 threads on the subject trying to glean enough to modify my code below without success. I'm hoping that while I continue to search and experiment, a helpful member might give some clue as to what I'm doing wrong.

Here is my code:

Please Login or Register  to view this content.

As you can see from the above code, I've got a worksheet called "NewRow" with some formatting and formulas in row 1, from A1 to BB1. It's basically a template. I try to copy this template when someone clicks the "New Record" button, then paste it to the next available row on my records sheet.

Column B is the only column that MUST be filled, so I'm using it to determine the last row. I'm getting a object doesn't support this property or method error on the following line;
Sheets("Records").Range("A" & nextRow).Paste
Regards,
AM

Finally got it! At least, finally found an answer on these forums that didn't require too much modification and could work for me.

Please Login or Register  to view this content.

Here's the thread that helped:

http://www.excelforum.com/excel-gene...empty-row.html