xlPasteType

Specifies the part of the range you want to paste.

xlPasteAll(-4104)
xlPasteAllExceptBorders(7)
xlPasteAllMergingConditionalFormats(Added in 2010) Everything will be pasted and conditional formats will be merged
(14)
xlPasteAllUsingSourceTheme(Added in 2007) (13)
xlPasteColumnWidths(8)
xlPasteComments(-4144)
xlPasteFormats(-4122)
xlPasteFormulas(-4123)
xlPasteFormulasAndNumberFormats(11)
xlPasteValidation(6)
xlPasteValues(-4163)
xlPasteValuesAndNumberFormats(12)

xlPasteAll
(-4104)
xlPasteAllExceptBorders
(7)
xlPasteAllMergingConditionalFormats
(Added in 2010) Everything will be pasted and conditional formats will be merged
(14)
xlPasteAllUsingSourceTheme
(Added in 2007) (13)
xlPasteColumnWidths
(8)
xlPasteComments
(-4144)
xlPasteFormats
(-4122)
xlPasteFormulas
(-4123)
xlPasteFormulasAndNumberFormats
(11)
xlPasteValidation
(6)
xlPasteValues
(-4163)
xlPasteValuesAndNumberFormats
(12)


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top