Worksheet.Paste Method
Pastes the contents of the Clipboard onto the worksheet.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Sub Paste ( _
Destination As Object, _
Link As Object _
)
void Paste(
Object Destination,
Object Link
)
Parameters
Destination
Type: System.ObjectA 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.Objecttrue 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.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.