Public Function CopyPaste(ByVal destCell As String, ByVal sourceArea As Area, ByVal properties As CopyPasteProperties) As Area
{signature}
{parameters}
{param:destCell}A string indicating the upper\-left cell of the destination area.{param}
{param:sourceArea}An area from the source workbook from which to copy.{param}
{param:properties}A [CopyPasteProperties|CopyPasteProperties] object that specifies the types of data to copy.{param}
{returns}An [Area|Area] object representing the set of cells populated with the copied values.{returns}
{remarks}
The copied data will +overwrite+ the contents of the cells in this worksheet. You may specify the types of data copied \(cell value, formulas, comments, formatting, etc.\) using the CopyPasteProperties object.
{remarks}
{example}{code:csharp|title=C#} |