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
P
PivotCache Method
PivotCaches Method
PivotFields Method
PivotItems Method
PivotSelect Method
PivotTables Method
PivotTableWizard Method
Play Method
Points Method
PointsToScreenPixelsX Method
PointsToScreenPixelsY Method
Post Method
PresetDrop Method
PresetGradient Method
PresetTextured Method
Previous Method
PrevNode Method
PrintOut Method
PrintPreview Method
Protect Method
ProtectSharing Method
Publish Method
PurgeChangeHistoryNow Method
Expand Minimize

PasteSpecial Method [Excel 2003 VBA Language Reference]

Office 2003

Pastes a Range from the Clipboard into the specified range.

expression.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)

expression Required. An expression that returns a Range object.

XlPasteType can be one of these XlPasteType constants.
xlPasteAll default
xlPasteAllExceptBorders
xlPasteColumnWidths
xlPasteComments
xlPasteFormats
xlPasteFormulas
xlPasteFormulasAndNumberFormats
xlPasteValidation
xlPasteValues
xlPasteValuesAndNumberFormats

XlPasteSpecialOperation can be one of these XlPasteSpecialOperation constants.
xlPasteSpecialOperationAdd
xlPasteSpecialOperationDivide
xlPasteSpecialOperationMultiply
xlPasteSpecialOperationNone default
xlPasteSpecialOperationSubtract

SkipBlanks   Optional Variant. True to have blank cells in the range on the Clipboard not be pasted into the destination range. The default value is False.

Transpose   Optional Variant. True to transpose rows and columns when the range is pasted.The default value is False.

Pastes the contents of the Clipboard onto the sheet, using a specified format. Use this method to paste data from other applications or to paste data in a specific format.

expression.PasteSpecial(Format, Link, DisplayAsIcon, IconFileName, IconIndex, IconLabel, NoHTMLFormatting)

expression Required. An expression that returns a Worksheet object.

Format   Optional Variant. A string that specifies the Clipboard format of the data.

Link   Optional Variant. True to establish a link to the source of the pasted data. If the source data isn't suitable for linking or the source application doesn't support linking, this parameter is ignored. The default value is False.

DisplayAsIcon   Optional Variant. True to display the pasted as an icon. The default value is False.

IconFileName   Optional Variant. The name of the file that contains the icon to use if DisplayAsIcon is True.

IconIndex   Optional Variant. The index number of the icon within the icon file.

IconLabel   Optional Variant. The text label of the icon.

NoHTMLFormatting   Optional Variant. True to remove all formatting, hyperlinks, and images from HTML. False to paste HTML as is. The default value is False.

Remarks

Note  NoHTMLFormatting will only matter when Format = "HTML". In all other cases, NoHTMLFormatting will be ignored.

You must select the destination range before you use this method.

This method may modify the sheet selection, depending on the contents of the Clipboard.

Example

This example replaces the data in cells D1:D5 on Sheet1 with the sum of the existing contents and cells C1:C5 on Sheet1.

With Worksheets("Sheet1")
    .Range("C1:C5").Copy
    .Range("D1:D5").PasteSpecial _
        Operation:=xlPasteSpecialOperationAdd
End With
				

This example pastes a Microsoft Word document object from the Clipboard to cell D1 on Sheet1.

Worksheets("Sheet1").Range("D1").Select
ActiveSheet.PasteSpecial format:= _
    "Microsoft Word 8.0 Document Object"
				

This example pastes the same Microsoft Word document object and displays it as an icon.

Worksheets("Sheet1").Range("F5").Select
ActiveSheet.PasteSpecial _
        Format:="Microsoft Word 8.0 Document Object", _
        DisplayAsIcon:=True

				




Show:
© 2015 Microsoft