Paste Method

Office 2013 and later

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 into the specified range on the datasheet.


expression Required. An expression that returns a Range object.

Link Optional Variant. True to establish a link to the source of the pasted data. The default value is False.

This example pastes the contents of the Clipboard into cell A1 on the datasheet.