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 |
|