Styles.Merge Method (Excel)
Merges the styles from another workbook into the Styles collection.
Syntax
식 .Merge(Workbook)
식 A variable that represents a Styles object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Workbook |
필수 |
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")