Export (0) Print
Expand All

Range.AddComment Method

Office 2007
Adds a comment to the range.

Syntax

expression.AddComment(Text)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
TextOptionalVariantThe comment text.

Return Value
Comment

Example

This example adds a comment to cell E5 on worksheet one.

Visual Basic for Applications
Worksheets(1).Range("E5").AddComment "Current Sales"



Community Additions

ADD
Show:
© 2014 Microsoft