Syntax

expression.Merge(Workbook)

expression A variable that represents a Styles object.

Parameters

Name Required/Optional Data Type Description
Workbook Required Variant A object that represents the workbook containing styles to be merged.

Return Value
Variant

Remarks

The value of a merged range is specified in the cell of the range's upper-left corner.

Example

This example merges the styles from the workbook Template.xls into the active workbook.

Visual Basic for Applications
ActiveWorkbook.Styles.Merge Workbook:=Workbooks("TEMPLATE.XLS")

See also: