_Workbook.Comments Property

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property Comments As String
    Get
    Set
'Usage
Dim instance As _Workbook
Dim value As String

value = instance.Comments

instance.Comments = value
string Comments { get; set; }

Property Value

Type: System.String
Returns String.

Examples

This example deletes all comments added by Jean Selva on the active sheet.

For Each c in ActiveSheet.Comments     If c.Author= "Jean Selva" Then c.Delete Next

See Also

Reference

_Workbook Interface

_Workbook Members

Microsoft.Office.Interop.Excel Namespace