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")