Styles.Merge Method (Excel)

Merges the styles from another workbook into the Styles collection.

Syntax

expression. Merge( _Workbook_ )

expression A variable that represents a Styles object.

Parameters

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

Return value

Variant

Example

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

ActiveWorkbook.Styles.Merge Workbook:=Workbooks("TEMPLATE.XLS")

See also

Styles Object