Worksheet.Paste(Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Pastes the contents of the Clipboard onto the worksheet.
public void Paste (object Destination, object Link);
abstract member Paste : obj * obj -> unit
Public Sub Paste (Optional Destination As Object, Optional Link As Object)
Parameters
- Destination
- 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
- 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.