Expand Minimize

Range.PasteAndFormat Method (Word)

Pastes the selected table cells and formats them as specified.

expression .PasteAndFormat(Type)

expression Required. A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

Type

Required

WdRecoveryType

The type of formatting to use when pasting the selected table cells.

This example pastes a selected Microsoft Excel chart as a picture. This example assumes that the Clipboard contains an Excel chart.

Sub PasteChart() 
 Selection.PasteAndFormat Type:=wdChartPicture 
End Sub

Community Additions

ADD
Show:
© 2014 Microsoft