Item Method

Applies To

All collections.

Description

Accessor. Returns part of a collection. The Item method works like the accessor method for a collection. For example, the following two lines of code are equivalent.


ActiveWorkbook.Worksheets.Item(1)
ActiveWorkbook.Worksheets(1)

For more information about accessing an individual member of a collection, see the accessor method or property listed in the following table.

AddIns

EditBoxes

PivotItems

Arcs

Excel4IntlMacroSheets

PivotTables

AreaGroups

Excel4MacroSheets

Points

Axes

GroupBoxes

RadarGroups

BarGroups

GroupObjects

Range

Borders

HiddenFields

Rectangles

BuiltinDocumentProperties

HiddenItems

RowFields

Buttons

Labels

Rows

Cells

LegendEntries

Scenarios

Characters

LineGroups

ScrollBars

ChartGroups

Lines

SeriesCollection

ChartObjects

ListBoxes

Sheets

Charts

MenuBars

ShortcutMenus

CheckBoxes

MenuItems

Spinners

ChildItems

Menus

Styles

ColumnFields

Modules

TextBoxes

ColumnGroups

Names

ToolbarButtons

Columns

OLEObjects

Toolbars

CustomDocumentProperties

OptionButtons

Trendlines

DataFields

Ovals

VisibleFields

DialogSheets

PageFields

VisibleItems

Dialogs

Panes

Windows

DoughnutGroups

ParentItems

Workbooks

DrawingObjects

Pictures

Worksheets

Drawings

PieGroups

XYGroups

DropDowns

PivotFields