Comment Property

Applies To

Range object, Scenario object.

Description

Range object: Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range. Read-only.

Scenario object: Returns or sets the comment associated with the scenario. The comment text cannot exceed 255 characters. Read/write String.

See Also

ChangeScenario method, ChangingCells property, NoteText method.

Example

This example sets the comment for scenario one on Sheet1.

Worksheets("Sheet1").Scenarios(1).Comment = _
    "Worst case July 1993 sales"