Scenario and Scenarios Members

Use the Scenarios collection to create new scenarios. Use the Worksheet object’s Scenarios method to get a reference to this collection. Use the Scenario object to set the criteria of the scenario. The Scenarios collection and Scenario object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Add 1

Application 2

ChangeScenario

ChangingCells

Comment

Count 1

Creator 2

CreateSummary 1

Delete

Hidden

Index

Item 1

Locked

Merge 1

Name

Parent 2

Show

Values

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial