Applies To
Styles Collection.
Description
Syntax 1: Merges the scenarios from another sheet into the collection of scenarios.
Syntax 2: Merges the styles from another workbook into the collection of styles.
Syntax 1
object.Merge(source)
Syntax 2
object.Merge(workbook)
object
Required. The Scenarios or Styles object.
source
Required for Syntax 1. The Worksheet object, or name of the sheet containing scenarios to merge.
workbook
Required for Syntax 2. The Workbook object containing styles to merge.
Example
This example merges the styles from the workbook TEMPLATE.XLS into the active workbook.
ActiveWorkbook.Styles.Merge Workbook:=Workbooks("TEMPLATE.XLS")