Paste noun U (STICKY SUBSTANCE) a thick soft sticky substance made by mixing a liquid with a powder, especially to make a type of glue: flour-and-water paste. Wallpaper paste. Flex Paste 3 lb Tub (White) Bundle with Allway Tools Putty 3-Piece Knife Set (2 Items) 3.8 out of 5 stars 18. Get it as soon as Fri, Apr 2. FREE Shipping by Amazon. Only 1 left in stock - order soon. More Buying Choices $48.99 (6 new offers).
-->Pastes the contents of the Clipboard onto the sheet.
Syntax
expression.Paste (Destination, Link)
expression A variable that represents a Worksheet object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Destination | Optional | Variant | 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 | Optional | Variant | 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.
Pastel Background
This method may modify the sheet selection, depending on the contents of the Clipboard.
Pastel Colors
Example
Pastebin.com
This example copies data from cells C1:C5 on Sheet1 to cells D1:D5 on Sheet1.
Support and feedback
Pastebin Roblox Scripts
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.