Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellRange Class / CutAndPasteTo Method / CutAndPasteTo(String,PasteOptions,Worksheet) Method
The Address of the Cell used as the target location for pasting the CellRange.
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(String,PasteOptions,Worksheet) Method
    In This Topic
    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.  
    Syntax
    'Declaration
     
    
    Public Overloads Sub CutAndPasteTo( _
       ByVal cellAddress As String, _
       Optional ByVal pasteOptions As PasteOptions, _
       Optional ByVal otherWorksheet As Worksheet _
    ) 
    'Usage
     
    
    Dim instance As CellRange
    Dim cellAddress As String
    Dim pasteOptions As PasteOptions
    Dim otherWorksheet As Worksheet
     
    instance.CutAndPasteTo(cellAddress, pasteOptions, otherWorksheet)

    Parameters

    cellAddress
    The Address of the Cell used as the target location for pasting the CellRange.
    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