Scenario Properties

Name

Returns

Description

ChangingCells

Range

Read-only. Returns the range of cells in the worksheet that will have values plugged in for the specific scenario

Comment

String

Set/Get the scenario comment

Hidden

Boolean

Set/Get whether the scenario is hidden

Index

Long

Read-only. Returns the spot in the collection where the current Scenario object is located

Locked

Boolean

Set/Get whether the scenario cannot be modified when the worksheet is protected

Name

String

Set/Get the name of the scenario

Values

Variant

Read-only. Parameters: [Index] . Returns an array of the values to plug into the changing cells for this particular scenario

0 0

Post a comment