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