Comment.Previous Method (Excel)
Returns a Comment object that represents the previous comment.
Syntax
expression .Previous
expression An expression that returns a Comment object.
Return Value
Comment
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 deletes every second comment, navigating with the Previous method.
Note
Please test in a new workbook with no existing comments. To clear all comments from a workbook use Selection.SpecialCells(xlCellTypeComments).Delete in the Immediate Pane.
'Sets up the comments
For xNum = 1 To 10
Range("A" & xNum).AddComment
Range("A" & xNum).Comment.Text Text:="Comment " & xNum
Next
MsgBox "Comments created... A1:A10"
'Deletes every second comment in the A1:A10 range
For yNum = 10 To 1 Step -2
Range("A" & yNum).Comment.Previous.Shape.Select True
Selection.Delete
Next
MsgBox "Deleted every second comment"