Excel copy and paste

[cdms]

Has anyone done much with Excel 2008. I am trying to copy a row from one sheet into another. I have found the required row and copied it to the pasteboard.

Code:

1 tell sheet "Sheet name" of workbook 1
2  select
3 end tell
4 set theRow to first row index of (find range "A1:J2000" what theAccountNo)
5 tell row theRow of sheet "Sheet name" of workbook 1
6  select
7 end tell
8 copy range selection

   
I want to paste this into the first row of a new empty sheet but cannot get the paste command to work.

Code:

1 paste range "A1" of sheet "Sheet1"

Any help appreciated.