_Worksheet.Paste Method

  • Article

Pastes the contents of the Clipboard onto the sheet.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub Paste ( _
    Destination As Object, _
    Link As Object _
)
'Usage
Dim instance As _Worksheet
Dim Destination As Object
Dim Link As Object

instance.Paste(Destination, Link)

void Paste(
    Object Destination,
    Object Link
)

Parameters

  • Destination
    Type: System.Object

    Optional 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

    Optional 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 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.

See Also

Reference

_Worksheet Interface

_Worksheet Members

Microsoft.Office.Interop.Excel Namespace