Options.PasteMergeFromXL Property

  • Article
Word Developer Reference

True to merge table formatting when pasting from Microsoft Excel. Read/write Boolean.

Syntax

expression.PasteMergeFromXL

expression   A variable that represents a Options object.

Example

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

Visual Basic for Applications 
  Sub AdjustExcelFormatting()
    With Options
        If .PasteMergeFromXL = False Then
            .PasteMergeFromXL = True
        End If
    End With
End Sub

See Also