CutAndPasteTo Method

Cuts a CellRange & pastes it to another location.

Overload List

Overload	Description
CutAndPasteTo(String,PasteOptions,Worksheet)	Removes 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.
CutAndPasteTo(Int32,Int32,PasteOptions,Worksheet)	Removes 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

// Cuts a CellRange & pastes it using the Address of a Cell to identify the target location, which will be located in another Worksheet, identified by the otherSheet object. All content, as well as its formatting, will be pasted to this new location.
Worksheet otherSheet = workbook.Worksheet[ 0 ]; 
 
worksheet.Cells[ "D4", "H12" ].CutAndPasteTo( "C3", PasteOptions.All, 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