Collection: Sheets

Collection: Sheets

Collection of all Worksheets. Use the sheets collection to access individual worksheets of the open work folder.

The following example generates a new channel group which has the name of the first worksheet:

Dim oCurrSheet
Set oCurrSheet = Workbook.Sheets.Item(1)
Call Root.ChannelGroups.Add(oCurrSheet.Name)