XlPasteType XlPasteType XlPasteType Enum


Specifies the part of the range to be pasted.

public enum class XlPasteType
public enum XlPasteType
Public Enum XlPasteType


xlPasteAll xlPasteAll xlPasteAll -4104

Everything will be pasted.

xlPasteAllExceptBorders xlPasteAllExceptBorders xlPasteAllExceptBorders 7

Everything except borders will be pasted.

xlPasteAllMergingConditionalFormats xlPasteAllMergingConditionalFormats xlPasteAllMergingConditionalFormats 14
xlPasteAllUsingSourceTheme xlPasteAllUsingSourceTheme xlPasteAllUsingSourceTheme 13

Everything will be pasted using the source theme.

xlPasteColumnWidths xlPasteColumnWidths xlPasteColumnWidths 8

The column width of the source cell will be applied to the destination cell.

xlPasteComments xlPasteComments xlPasteComments -4144

Comments will be pasted.

xlPasteFormats xlPasteFormats xlPasteFormats -4122

Formatting will be pasted.

xlPasteFormulas xlPasteFormulas xlPasteFormulas -4123

Formulas will be pasted.

xlPasteFormulasAndNumberFormats xlPasteFormulasAndNumberFormats xlPasteFormulasAndNumberFormats 11

Formulas and number formats are pasted.

xlPasteValidation xlPasteValidation xlPasteValidation 6

Validation from the source cell is applied to the destination cell.

xlPasteValues xlPasteValues xlPasteValues -4163

Only the values will be pasted.

xlPasteValuesAndNumberFormats xlPasteValuesAndNumberFormats xlPasteValuesAndNumberFormats 12

Only the values number formats will be pasted.

Applies to