Copy to first empty row in new workbook

[Jeffrey Lebowski]

Hi,

I am working on code for a userform that allows the user to select one of two options:
1)copy sheet 2 and paste in new workbook
or
2)copy row 2 to last row of data in sheet 2 and paste in existing workbook, at first empty row

I have got option 1 to work but cant figure out option 2. here is code. thanks for help!

Please Login or Register  to view this content.

[tehneXus]

try

Please Login or Register  to view this content.