WorksheetBase.Paste Method

  • Article

Pastes the contents of the Clipboard onto the worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Sub Paste ( _
    destination As Object, _
    link As Object _
)

public void Paste(
    Object destination,
    Object link
)

Parameters

  • destination
    Type: System.Object

    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
    Type: System.Object

    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.

Remarks

If you do not specify the Destination argument, you must select the destination range before you use this method.

This method might modify the sheet selection, depending on the contents of the Clipboard.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example places the text "Paste Example" onto the Clipboard, and then uses the Paste method to paste the contents of the Clipboard into cell A1.

This example is for a document-level customization.

Private Sub PasteText()
    Clipboard.SetText("Paste Example")
    Me.Paste(Me.Range("A1"), False)
End Sub

private void PasteText()
{
    Clipboard.SetText("Paste Example");
    this.Paste(this.Range["A1"], false);
}

.NET Framework Security

See Also

Reference

WorksheetBase Class

Microsoft.Office.Tools.Excel Namespace