Scenarios.CreateSummary Method

Creates a new worksheet that contains a summary report for the scenarios on the specified worksheet.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function CreateSummary ( _
    ReportType As XlSummaryReportType, _
    ResultCells As Object _
) As Object
'Usage
Dim instance As Scenarios
Dim ReportType As XlSummaryReportType
Dim ResultCells As Object
Dim returnValue As Object

returnValue = instance.CreateSummary(ReportType, _
    ResultCells)

Object CreateSummary(
    XlSummaryReportType ReportType,
    Object ResultCells
)

Parameters

• ReportType
  Type: Microsoft.Office.Interop.Excel.XlSummaryReportType

  Optional XlSummaryReportType.

• ResultCells
  Type: System.Object

  Optional Object. 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 — that is, the cells that show the results of a particular scenario. If this argument is omitted, there are no result cells included in the report.

Return Value

Type: System.Object

See Also

Reference

Scenarios Interface

Scenarios Members

Microsoft.Office.Interop.Excel Namespace