Previous Method

Microsoft Excel Visual Basic

Returns a Comment object that represents the previous comment.

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