TextRange2.PasteSpecial method (Office)

Replaces the text range with the contents of the Clipboard in the format specified. If the paste succeeds, this method returns a TextRange2 object, including the text range that was pasted.


expression.PasteSpecial (Format)

expression An expression that returns a TextRange2 object.


Name Required/Optional Data type Description
Format Required MsoClipboardFormat Determines the format for the Clipboard contents when they're inserted into the document.

Return value


See also

Support and feedback

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.