CopyAndPasteTo Method (CellRange)

Copies a CellRange & pastes it to another location.

Overload List

Overload	Description
CopyAndPasteTo(String,PasteOptions,Worksheet,CopyOptions)	Copies the CellRange from its current location and pastes it to a new location, using the Address of a Cell to determine where the data will be pasted.
CopyAndPasteTo(Int32,Int32,PasteOptions,Worksheet,CopyOptions)	Copies the CellRange from its current location and pastes it to a new location, using a RowID & a ColumnID to determine where the data will be pasted.

Example

// Copies a CellRange & pastes it using a RowID & A ColumnID to identify the target location, which will be located in another Worksheet, identified by the otherSheet object. All content will be pasted to the new location, but the content from the rows will be pasted into columns & the content of the columns will be pasted into rows.
Worksheet otherSheet = workbook.Worksheet[ 0 ]; 
 
worksheet.Cells[ "D4", "F12" ].CopyAndPasteTo( 15, 5 , PasteOptions.All | PasteOptions.Transpose, otherSheet );

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CellRange Class
CellRange Members