title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Range.AddComment method (Excel) |
vbaxl10.chm144222 |
|
|
89bbacad-4655-bcc1-8010-2ab367cc7b31 |
05/10/2019 |
medium |
Adds a comment to the range.
expression.AddComment (Text)
expression A variable that represents a Range object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Text | Optional | Variant | The comment text. |
Comment
This example adds a comment to cell E5 on worksheet one.
Worksheets(1).Range("E5").AddComment "Current Sales"
[!includeSupport and feedback]