Xceed Workbooks for .NET v2.0 Documentation
CutAndPasteTo(Int32,Int32,PasteOptions,Worksheet) Method


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace > CellRange Class > CutAndPasteTo Method : CutAndPasteTo(Int32,Int32,PasteOptions,Worksheet) Method
The RowID that will be used to determine the location where the CellRange will be pasted.
The ColumnID used to determine the location where the CellRange will be pasted.
The PasteOptions; in other words, what type of data will be pasted into the new location.
The Worksheet in which the data will be pasted; by default, this is set to null, which means that the data will be pasted into the current 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. 
Syntax
'Declaration
 
Public Overloads Sub CutAndPasteTo( _
   ByVal rowId As Integer, _
   ByVal columnId As Integer, _
   Optional ByVal pasteOptions As PasteOptions, _
   Optional ByVal otherWorksheet As Worksheet _
) 
'Usage
 
Dim instance As CellRange
Dim rowId As Integer
Dim columnId As Integer
Dim pasteOptions As PasteOptions
Dim otherWorksheet As Worksheet
 
instance.CutAndPasteTo(rowId, columnId, pasteOptions, otherWorksheet)

Parameters

rowId
The RowID that will be used to determine the location where the CellRange will be pasted.
columnId
The ColumnID used to determine the location where the CellRange will be pasted.
pasteOptions
The PasteOptions; in other words, what type of data will be pasted into the new location.
otherWorksheet
The Worksheet in which the data will be pasted; by default, this is set to null, which means that the data will be pasted into the current Worksheet
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

See Also

Reference

CellRange Class
CellRange Members
Overload List