SpreadsheetGear 2023
Copy(IRange,PasteType,PasteOperation,Boolean,Boolean) Method


SpreadsheetGear Namespace > IRange Interface > Copy Method : Copy(IRange,PasteType,PasteOperation,Boolean,Boolean) Method
The destination range.
Specifies what to paste.
Specifies how to combine values.
Specifies whether blanks in the source range should be skipped (formatted cells with no data are considered blank cells).
Specifies whether data should be transposed in the destination.
Copies the cells, rows and/or columns of the current IRange to the destination IRange using the specified options.
Syntax
'Declaration
 
Overloads Sub Copy( _
   ByVal destination As IRange, _
   ByVal pasteType As PasteType, _
   ByVal pasteOperation As PasteOperation, _
   ByVal skipBlanks As System.Boolean, _
   ByVal transpose As System.Boolean _
) 
'Usage
 
Dim instance As IRange
Dim destination As IRange
Dim pasteType As PasteType
Dim pasteOperation As PasteOperation
Dim skipBlanks As System.Boolean
Dim transpose As System.Boolean
 
instance.Copy(destination, pasteType, pasteOperation, skipBlanks, transpose)

Parameters

destination
The destination range.
pasteType
Specifies what to paste.
pasteOperation
Specifies how to combine values.
skipBlanks
Specifies whether blanks in the source range should be skipped (formatted cells with no data are considered blank cells).
transpose
Specifies whether data should be transposed in the destination.
Remarks

Column widths, column formats and column outlines are copied if entire columns are being copied.

Row heights, row formats and row outlines are copied if entire rows are being copied.

Requirements

Target Platforms: 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

IRange Interface
IRange Members
Overload List
Copy(IRange) Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method