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