Can someone provide:

1. the syntax for copying a complete line from one spreadsheet to another?
Does the second one have to be open?

2. syntax for inserting a complete line in a different spreadsheet, on the
next blank line of a sheet, moving the rest on the lines down?

3. the syntax for copying a complete line at the end of a sheet on a
different spreadsheetspreadsheet.

I'm going to try to use that to put together a complicated macro.

Thanks,

Ron