property CopyOnAppend: Boolean

 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.