XlPasteType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the part of the range to be pasted.
public enum class XlPasteTypepublic enum XlPasteTypePublic Enum XlPasteType- Inheritance
-
XlPasteType
Fields
| Name | Value | Description |
|---|---|---|
| xlPasteValues | -4163 | Only the values will be pasted. |
| xlPasteComments | -4144 | Comments will be pasted. |
| xlPasteFormulas | -4123 | Formulas will be pasted. |
| xlPasteFormats | -4122 | Formatting will be pasted. |
| xlPasteAll | -4104 | Everything will be pasted. |
| xlPasteValidation | 6 | Validation from the source cell is applied to the destination cell. |
| xlPasteAllExceptBorders | 7 | Everything except borders will be pasted. |
| xlPasteColumnWidths | 8 | The column width of the source cell will be applied to the destination cell. |
| xlPasteFormulasAndNumberFormats | 11 | Formulas and number formats are pasted. |
| xlPasteValuesAndNumberFormats | 12 | Only the values number formats will be pasted. |
| xlPasteAllUsingSourceTheme | 13 | Everything will be pasted using the source theme. |
| xlPasteAllMergingConditionalFormats | 14 |