Comments.Item Method (Excel)

Returns a single object from a collection.

expression .Item(Index)

expression A variable that represents a Comments object.

Parameters

Name

Required/Optional

Data Type

Description

Index

Required

Long

The index number for the object.

Return Value

A Comment object contained by the collection.

This example hides comment two.

Worksheets(1).Comments.Item(2).Visible = False
Show:
© 2014 Microsoft