Xceed Workbooks for .NET v3.0 Documentation
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


In This Topic
    CutAndPasteTo(Int32,Int32,PasteOptions,Worksheet) Method
    In This Topic
    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