XlPasteType Enum


Specifies the part of the range to be pasted.

public enum class XlPasteType
public enum XlPasteType
Public Enum XlPasteType


xlPasteAll -4104

Everything will be pasted.

xlPasteAllExceptBorders 7

Everything except borders will be pasted.

xlPasteAllMergingConditionalFormats 14
xlPasteAllUsingSourceTheme 13

Everything will be pasted using the source theme.

xlPasteColumnWidths 8

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

xlPasteComments -4144

Comments will be pasted.

xlPasteFormats -4122

Formatting will be pasted.

xlPasteFormulas -4123

Formulas will be pasted.

xlPasteFormulasAndNumberFormats 11

Formulas and number formats are pasted.

xlPasteValidation 6

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

xlPasteValues -4163

Only the values will be pasted.

xlPasteValuesAndNumberFormats 12

Only the values number formats will be pasted.

Applies to