Specifies whether the current or last row's contents should be copied automatically to any newly inserted or appended rows.
Using the Append method will cause the last row to be copied, not the current row. If you wish to copy the current row's contents then you should use the Insert method.