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


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.   
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

Reference

CellRange Class
CellRange Members
Overload List