Method: Item for Sheets
- Updated2024-09-12
- 1 minute(s) read
DataPlugin > Methods > Method: Item for Sheets
Method: Item for Sheets
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)