Options.PasteMergeFromXL property (Word)

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.

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

See also

Options Object

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.