Styles.Merge Method

Excel Developer Reference

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.

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

See Also