Previous Method

Applies To

Comment object.

Description

Returns a Comment object that represents the previous comment.

Syntax

expression.Previous

expression Required. An expression that returns a Comment object.

Remarks

This method works only on one sheet. Using this method on the first comment on a sheet returns Null (not the last comment on the previous sheet).

Example

This example hides the previous comment.

Range("A1").Comment.Previous.Visible = False