Paste Method

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

expression.Paste(Link)

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.

myChart.Application.DataSheet.Range("A1").Paste
Show: