Paste Type Enumeration

Find below the list of Excel paste types as per XlPasteType enumeration. The paste type can be determined using either the name or value. A paste type can be specified when pasting a Range or Cell using the PasteSpecial method of the Range object.

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.



No comments:

Post a Comment

Popular Posts