Applies To
DialogSheet Object, Worksheet Object.
Description
Pastes the contents of the Clipboard onto the sheet.
Syntax
object.Paste(destination, link)
object
Required. The DialogSheet or Worksheet object.
destination
Optional. A Range specifying where the Clipboard contents should be placed. If omitted, the current selection is used. This argument can only be specified if the contents of the Clipboard can be pasted into a range—it cannot be used with drawing objects. If this argument is specified, the link argument cannot be used.
link
Optional. If True, a link is established to the source of the pasted data. If this argument is specified, the destination argument cannot be used.
Remarks
If you do not specify the destination argument, 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. For example, pasted drawing objects remain selected.
See Also
Copy Method, Cut Method, Paste Method (Chart Object), PasteSpecial Method.
Example
This example copies data from cells C1:C5 on Sheet1 to cells D1:D5 on Sheet1.
Worksheets("Sheet1").Range("C1:C5").Copy
ActiveSheet.Paste destination:=Worksheets("Sheet1").Range("D1:D5")