Method: Item for Sheets

Download PDF

Returns the Sheet object associated with a specific name or with a specific index.

Set oSheet = Object.Item(NameOrIndex)

Object	Sheets Object with this method
NameOrIndex	Variant Specifies the name or the index of a worksheet.
oSheet	Sheet Returned object

The following example accesses the first cell of the second worksheet:

Dim oCurrSheet, Name
Set oCurrSheet = Workbook.Sheets.Item(2)

Name = oCurrSheet.GetCellValue(1,1)

Examples