XlPasteType Enumeration
Specifies the part of the range to be pasted.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlPasteType
'Usage
Dim instance As XlPasteType
public enum XlPasteType
Members
| Member name | Description | |
|---|---|---|
| xlPasteAll | Everything will be pasted. | |
| xlPasteAllUsingSourceTheme | Everything will be pasted using the source theme. | |
| xlPasteAllExceptBorders | Everything except borders will be pasted. | |
| xlPasteFormats | Formatting will be pasted. | |
| xlPasteFormulas | Formulas will be pasted. | |
| xlPasteComments | Comments will be pasted. | |
| xlPasteValues | Only the values will be pasted. | |
| xlPasteColumnWidths | The column width of the source cell will be applied to the destination cell. | |
| xlPasteValidation | Validation from the source cell is applied to the destination cell. | |
| xlPasteFormulasAndNumberFormats | Formulas and number formats are pasted. | |
| xlPasteValuesAndNumberFormats | Only the values number formats will be pasted. |