Range.PasteSpecial Method (Excel)
Pastes a Range from the Clipboard into the specified range.
Syntax
expression .PasteSpecial(Paste, Operation, SkipBlanks, Transpose)
expression A variable that represents a Range object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Paste |
Optional |
. The part of the range to be pasted. |
|
Operation |
Optional |
. The paste operation. |
|
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. |
Return Value
Variant
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