Share via


XlPasteType Enumeration

Specifies the part of the range to be pasted.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlPasteAll

-4104

Everything will be pasted.

xlPasteAllExceptBorders

7

Everything except borders will be pasted.

xlPasteAllMergingConditionalFormats

14

Everything will be pasted and conditional formats will be merged.

xlPasteAllUsingSourceTheme

13

Everything will be pasted using the source theme.

xlPasteColumnWidths

8

Copied column width is pasted.

xlPasteComments

-4144

Comments are pasted.

xlPasteFormats

-4122

Copied source format is pasted.

xlPasteFormulas

-4123

Formulas are pasted.

xlPasteFormulasAndNumberFormats

11

Formulas and Number formats are pasted.

xlPasteValidation

6

Validations are pasted.

xlPasteValues

-4163

Values are pasted.

xlPasteValuesAndNumberFormats

12

Values and Number formats are pasted.