XlPasteType enumeration

Office 2013 and later

Specifies the part of the range to be pasted.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

No code example is currently available or this language may not be supported.

	Member name	Description
	xlPasteAll	Everything will be pasted.
	xlPasteAllUsingSourceTheme	Everything will be pasted using the source theme.
	xlPasteAllMergingConditionalFormats
	xlPasteAllExceptBorders	Everything except borders will be pasted.
	xlPasteFormats	Formatting will be pasted.
	xlPasteFormulas	Formulas will be pasted.
	xlPasteComments	Comments will be pasted.
	xlPasteValues	Only the values will be pasted.
	xlPasteColumnWidths	The column width of the source cell will be applied to the destination cell.
	xlPasteValidation	Validation from the source cell is applied to the destination cell.
	xlPasteFormulasAndNumberFormats	Formulas and number formats are pasted.
	xlPasteValuesAndNumberFormats	Only the values number formats will be pasted.