PASTE.SPECIAL Syntax 4

Macro Sheets Only

Equivalent to choosing the Paste Special command from the Edit menu when pasting data from another application into Microsoft Excel. Use syntax 4 when pasting information from another application.

Syntax

PASTE.SPECIAL(format_text, pastelink_logical, display_icon_logical, icon_file, icon_number, icon_label)
PASTE.SPECIAL?(format_text, pastelink_logical, display_icon_logical, icon_file, icon_number, icon_label)

Format_text is text specifying the type of data you want to paste from the Clipboard.

• The valid data types vary depending on the application from which the data was copied. For example, if you're copying data from Microsoft Word, some of the data types are "Microsoft Document Object", "Picture", and "Text".
• For more information about object classes, see your Microsoft Windows or Apple system software documentation.

Pastelink_logical is a logical value specifying whether to link the pasted data to its source application.

• If pastelink_logical is TRUE, Microsoft Excel updates the pasted information whenever it changes in the source application.
• If pastelink_logical is FALSE or omitted, the information is pasted without a link.
• If Microsoft Excel or the source application does not support linking for the specified format_text, then pastelink_logical is ignored.
• Display_icon_logical is a logical value that specifies whether you want an application's icon to be displayed on the worksheet instead of the linked data. Equivalent to the Display as Icon check box on the Paste Special dialog box. If TRUE, the application's icon will be displayed. If FALSE or omitted, the application's icon will not be displayed.
• Icon_file is the name of the file (with an .EXE or .DLL extension) that contains the icon. If display_icon_logical is FALSE, this argument is ignored.
• Icon_number is the number associated with the icon and corresponds to the icon's relative position within the Icon Drop Down list box on the Change Icon Dialog box, which appears when you choose the Change Icon button from the Paste Special dialog box. If display_icon_logical is FALSE, this argument is ignored.
• Icon_label is the caption that you want to appear below the icon, and is equivalent to the Caption text box on the Change Icon dialog box, which appears when you choose the Change Icon button from the Paste Special dialog box. If display_icon_logical is FALSE, this argument is ignored.

Related Functions

Syntax 1 Pasting into a sheet or macro sheet

Syntax 2 Copying from a sheet and pasting into a chart

Syntax 3 Copying and pasting between charts

List of Command-Equivalent Functions