Paste Method
TOC
Collapse the table of content
Expand the table of content

Worksheet.Paste Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Pastes the contents of the Clipboard onto the sheet.

expression .Paste(Destination, Link)

expression A variable that represents a Worksheet object.

Parameters

Name

Required/Optional

Data Type

Description

Destination

Optional

Variant

A Range object that specifies where the Clipboard contents should be pasted. If this argument is omitted, the current selection is used. This argument can be specified only if the contents of the Clipboard can be pasted into a range. If this argument is specified, the Link argument cannot be used.

Link

Optional

Variant

True to establish a link to the source of the pasted data. If this argument is specified, the Destination argument cannot be used. The default value is False.

If you don?t 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.

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")
Show:
© 2016 Microsoft