Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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)

Dim xlPasteType1 As XlPasteType = XlPasteType.xlPasteAll

public enum XlPasteType
public enum XlPasteType
public enum XlPasteType

Member nameDescription
xlPasteAllEverything will be pasted.
xlPasteAllExceptBordersEverything except borders will be pasted.
xlPasteColumnWidthsThe column width of the source cell will be applied to the destination cell.
xlPasteCommentsComments will be pasted.
xlPasteFormatsFormatting will be pasted.
xlPasteFormulasFormulas will be pasted.
xlPasteFormulasAndNumberFormatsFormulas and number formats are pasted.
xlPasteValidationValidation from the source cell is applied to the destination cell.
xlPasteValuesOnly the values will be pasted.
xlPasteValuesAndNumberFormatsOnly the values number formats will be pasted.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2015 Microsoft