Property: Sheets for Workbook

Property: Sheets for Workbook

Returns a collection of the worksheets of a workbook.

Set oSheets = Object.Sheets

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)