Worksheet.PasteSpecial (Excel)

Pastes the contents of the Clipboard onto the sheet, using a specified format. Use this method to paste data from other applications or to paste data in a specific format.

PasteSpecial (Format, Link, DisplayAsIcon, IconFileName, IconIndex, IconLabel, NoHTMLFormatting)

ActiveSheet.PasteSpecial format:= _ 
 "Microsoft Word 8.0 Document Object"


The following arguments are optional

Format (String) - A string that specifies the Clipboard format of the data.

Link (Boolean) - True to establish a link to the source of the pasted data. If the source data isn't suitable for linking or the source application doesn't support linking, this parameter is ignored. The default value is False.

DisplayAsIcon (Boolean) - True to display the pasted data as an icon. The default value is False.

IconFileName (String) - The name of the file that contains the icon to use if DisplayAsIcon is True.

IconIndex - The index number of the icon within the icon file

IconLabel (String) - The text label of the icon.

NoHTMLFormatting (Boolean) - True to remove all formatting, hyperlinks, and images from HTML. False to paste HTML as is. The default value is False.