Item Property
Item property as it applies to the Borders object.
Returns a Border object that represents the specified border.
expression.Item(Index)
expression Required. An expression that returns a Border object.
Index Required XlBordersIndex. The border that you want to return.
| XlBordersIndex can be one of these XlBordersIndex constants. |
| xlEdgeBottom |
| xlEdgeLeft |
| xlEdgeRight |
| xlEdgeTop |
| xlInsideHorizontal |
| xlInsideVertical |
Item property as it applies to the ChCategoryLabels object.
Returns a ChCategoryLabel object that represents the specified category label.
expression.Item(Level, Index)
expression Required. An expression that returns one of the above objects.
Level Optional Long. The level of category labels that you want to index.
Index Required Variant. The name or index number of the category label that you want to return.
Item property as it applies to the PivotMemberProperties and PivotResultMemberProperties objects.
Returns a PivotMemberProperty object that represents the specified member property.
expression.Item(varIndex)
expression Required. An expression that returns one of the above objects.
varIndex Required Variant. The name or index number of the member property that you want to return.
Item property as it applies to the Range object.
Returns a Range object that represents a specific cell within the specified range of cells.
expression.Item(RowIndex, ColumnIndex)
expression Required. An expression that returns a Range object.
RowIndex Required Variant. The row index of the cell that you want to return.
ColumnIndex Optional Variant. The column index of the cell that you want to return.
Item property as it applies to all other objects in the Applies To list.
Returns a single object from the specified collection. The Item property is the default property for most collections, so it is usually not necessary to explicitly use this property. For more information about returning a single member of a collection, see Returning an Object from a Collection.
expression.Item(Index)
expression An expression that returns an object in the Applies To list.
Index Required Long or Variant, depending on the object specified in expression (for a list of allowed argument types by object, see the Object Browser). The name or index number of the object that will be returned.