GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IRange Interface / PasteSpecial Method
The part of the range to be pasted.
The paste operation.
true to have blank cells in the range on the clipboard not be pasted into the destination range.
true to transpose rows and columns when the range is pasted.


In This Topic
PasteSpecial Method (IRange)
In This Topic
Creates a command that paste specified data to the worksheet.
Syntax
'Declaration
 
Sub PasteSpecial( _
   ByVal paste As PasteType, _
   ByVal operation As PasteSpecialOperation, _
   Optional ByVal skipBlanks As Boolean, _
   Optional ByVal transpose As Boolean _
) 
 
'Usage
 
Dim instance As IRange
Dim paste As PasteType
Dim operation As PasteSpecialOperation
Dim skipBlanks As Boolean
Dim transpose As Boolean
 
instance.PasteSpecial(paste, operation, skipBlanks, transpose)

Parameters

paste
The part of the range to be pasted.
operation
The paste operation.
skipBlanks
true to have blank cells in the range on the clipboard not be pasted into the destination range.
transpose
true to transpose rows and columns when the range is pasted.
See Also