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)

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;



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


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

  • xlPasteSpecialOperationAdd

  • xlPasteSpecialOperationDivide

  • xlPasteSpecialOperationMultiply

  • xlPasteSpecialOperationNonedefault

  • xlPasteSpecialOperationSubtract


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


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

© 2015 Microsoft