Export (0) Print
Expand All
Expand Minimize
0 out of 11 rated this helpful - Rate this topic

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)

'Usage
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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.