PasteSpecial method
Collapse the table of content
Expand the table of content

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)

Object PasteSpecial(
	XlPasteType Paste,
	XlPasteSpecialOperation Operation,
	Object SkipBlanks,
	Object Transpose


Type: Microsoft.Office.Interop.Excel.XlPasteType

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

Type: Microsoft.Office.Interop.Excel.XlPasteSpecialOperation

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

  • xlPasteSpecialOperationAdd

  • xlPasteSpecialOperationDivide

  • xlPasteSpecialOperationMultiply

  • xlPasteSpecialOperationNonedefault

  • xlPasteSpecialOperationSubtract

Type: System.Object

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

Type: System.Object

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

Return value

Type: System.Object
© 2016 Microsoft