This documentation is archived and is not being maintained.

XlPasteType Enumeration

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)

public enum XlPasteType

Member nameDescription
xlPasteAllEverything will be pasted.
xlPasteAllUsingSourceThemeEverything will be pasted using the source theme.
xlPasteAllExceptBordersEverything except borders will be pasted.
xlPasteFormatsFormatting will be pasted.
xlPasteFormulasFormulas will be pasted.
xlPasteCommentsComments will be pasted.
xlPasteValuesOnly the values will be pasted.
xlPasteColumnWidthsThe column width of the source cell will be applied to the destination cell.
xlPasteValidationValidation from the source cell is applied to the destination cell.
xlPasteFormulasAndNumberFormatsFormulas and number formats are pasted.
xlPasteValuesAndNumberFormatsOnly the values number formats will be pasted.