expression.CreateSummary(ReportType, ResultCells)
expression Required. An expression that returns one of the objects in the Applies To list.
ReportType Optional XlSummaryReportType.
XlSummaryReportType can be one of these XlSummaryReportType constants. |
xlSummaryPivotTable |
xlStandardSummary default |
ResultCells Optional Variant. A Range object that represents the result cells on the specified worksheet. Normally, this range refers to one or more cells containing the formulas that depend on the changing cell values for your model
Example
This example creates a summary of the scenarios on Sheet1, with result cells in the range C4:C9 on Sheet1.
Worksheets("Sheet1").Scenarios.CreateSummary _
ResultCells := Worksheets("Sheet1").Range("C4:C9")