'Declaration
 
Public Overloads Sub CopyAndPasteTo( _
   ByVal cellAddress As String, _
   Optional ByVal pasteOptions As PasteOptions, _
   Optional ByVal otherWorksheet As Worksheet, _
   Optional ByVal copyOption As CopyOptions _
) 

'Usage
 
Dim instance As CellRange
Dim cellAddress As String
Dim pasteOptions As PasteOptions
Dim otherWorksheet As Worksheet
Dim copyOption As CopyOptions
 
instance.CopyAndPasteTo(cellAddress, pasteOptions, otherWorksheet, copyOption)

public void CopyAndPasteTo( 
   string cellAddress,
   PasteOptions pasteOptions,
   Worksheet otherWorksheet,
   CopyOptions copyOption
)

Parameters

cellAddress

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

copyOption

The CopyOptions; by default, this is set to Copy.   

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
Overload List