Range.AddComment Method (Excel)
Adds a comment to the range.
Syntax
expression .AddComment(Text)
expression A variable that represents a Range object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Text |
Optional |
Variant |
The comment text. |
Return Value
Comment
Example
This example adds a comment to cell E5 on worksheet one.
Worksheets(1).Range("E5").AddComment "Current Sales"