Export (0) Print
Expand All
Expand Minimize

Range.PasteSpecial Method 

Pastes a Range from the Clipboard into the specified range.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim Paste As XlPasteType
Dim Operation As XlPasteSpecialOperation
Dim SkipBlanks As Object
Dim Transpose As Object
Dim returnValue As Object
Dim range1 As Range
returnValue = range1.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)

object PasteSpecial(
	[In, Optional] XlPasteType Paste, 
	[In, Optional] XlPasteSpecialOperation Operation, 
	[In, Optional] object SkipBlanks, 
	[In, Optional] object Transpose
);
public System.Object PasteSpecial(
	/*in*/XlPasteType Paste, 
	/*in*/XlPasteSpecialOperation Operation, 
	/*in*/System.Object SkipBlanks, 
	/*in*/System.Object Transpose
);
function PasteSpecial(
	 Paste : XlPasteType, 
	 Operation : XlPasteSpecialOperation, 
	 SkipBlanks : Object, 
	 Transpose : Object
) : Object;

Parameters

Paste

Optional XlPasteType. The part of the range to be pasted. Can be one of the following XlPasteType constants:

  • xlPasteAll default

  • xlPasteAllExceptBorders

  • xlPasteColumnWidths

  • xlPasteComments

  • xlPasteFormats

  • xlPasteFormulas

  • xlPasteFormulasAndNumberFormats

  • xlPasteValidation

  • xlPasteValues

  • xlPasteValuesAndNumberFormats

Operation

Optional XlPasteSpecialOperation. The paste operation. Can be one of the following XlPasteSpecialOperation constants:

  • xlPasteSpecialOperationAdd

  • xlPasteSpecialOperationDivide

  • xlPasteSpecialOperationMultiply

  • xlPasteSpecialOperationNonedefault

  • xlPasteSpecialOperationSubtract

SkipBlanks

Optional Object. True to not have blank cells in the range on the Clipboard pasted into the destination range. The default value is False.

Transpose

Optional Object. True to transpose rows and columns when the range is pasted. The default value is False.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft