SCENARIO.GET macro
Returns the specified information about the scenarios defined on your worksheet.
Syntax
SCENARIO.GET(type_num, scen_name)
Type_num is a number from 1 to 8 specifying the type of information you want.
Type_num
|
Information returned
|
1
|
A horizontal array of all scenario names in the form of text
|
2
|
A reference to the set of changing cells of scen_name (specified in the Changing Cells box of the Scenario Manager dialog box). If scen_name is omitted, the first scenario is used.
|
3
|
A reference to the result cells (specified in the Result Cells box in the Scenario Summary dialog box)
|
4
|
An array of scenario values for the scenario scen_name . Each scenario is in a separate row. If scen_name is omitted, the first scenario is used.
|
5
|
Comment, as text, for the scenario
|
6
|
Returns TRUE if the specified scenario is locked to prevent changes; FALSE, if unlocked. Scen_name is required.
|
7
|
Returns TRUE if the specified scenario is hidden; FALSE, if visible to the user. Scen_name is required.
|
8
|
Returns the user name of the person who last modified the scenario by either adding or editing a scenario. Scen_name is required.
|
Scen_name is the name of the scenario that you want information about. Ignored if type_num equals 1 or 3.
Remarks
In the returned array of scenario values, the number of rows is the number of scenarios, and the number of columns is the number of changing cells.
Return to index