Worksheet.Comments (Excel)

Returns a Comments collection that represents all the comments for the specified worksheet.

Dim cmmsComments As Comments
Set cmmsComments = ActiveSheet.Comments