Worksheet.Scenarios (Excel)

Returns an scenarios that represents either a single scenario (a Scenario) or a collection of scenarios (a Scenarios collection) on the worksheet.

Scenarios (Index)

Index: The name or number of the scenario. Use an array to specify more than one scenario.

Dim scns As Scenarios
Set scns = ActiveSheet.Scenarios()