Share via

Comment Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

Comment property as it applies to the Range object.

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

expression.Comment

expression   Required. An expression that returns a Range object.

Comment property as it applies to the Scenario object.

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

expression.Comment

expression   Required. An expression that returns a Scenario object.

Example

This example sets the comment for scenario one on Sheet1.

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