PasteMergeFromXL Property

expression.PasteMergeFromXL

expression    Required. An expression that returns one of the objects in the Applies To list.

Example

This example sets Microsoft Word to automatically merge table formatting when pasting Excel tables if the option has been disabled.

Sub AdjustExcelFormatting()
    With Options
        If .PasteMergeFromXL = False Then
            .PasteMergeFromXL = True
        End If
    End With
End Sub