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