Method: Item for Sheets
- Updated2024-09-12
- 1 minute(s) read
DIAdem VIEW > Methods > Method: Item for Sheets
Method: Item for Sheets
Returns the Sheet object associated with a specific name or index in DIAdem VIEW.
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 |
 |
Note You can always omit the Item method because it is the standard element of the collection. |
The following example displays a message with the name of the first worksheet. The second line of the example is the simplified form of the first line:
| VBScript | Python |
Call MsgBoxDisp("Name of first sheet: " & View.Sheets.Item(1).Name) Call MsgBoxDisp("Name of first sheet: " & View.Sheets(1).Name)