Next Method

Microsoft Excel Visual Basic

Next Method

       

Returns a Comment object that represents the next comment.

expression.Next

expression   Required. An expression that returns a Comment object.

Remarks

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

Example

This example hides the next comment.

Range("a1").Comment.Next.Visible = False