The PasteSpecial method inserts clipboard contents using the specified format into the range area. Cells that lie outside the range do not paste. Returns a Boolean.
Syntax
object.PasteSpecial( Format, ClipToRange )
Parameter |
Type |
Description |
Format |
required; paste format |
|
ClipToRange |
Boolean |
optional, default=0 |
Example
This example demonstrates how to paste clipboard contents as text only with a range.
WksRange. PasteSpecial (Format:=wksClipboardText, ClipToRange:=True)
Used by: WksRange object