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. |