Property: Worksheets for Workbook

Property: Worksheets for Workbook

Returns a collection of the Excel worksheets.

Set oWorksheets = Object.Worksheets

The following example creates an Excel workbook and returns the number of worksheets. Refer to the help pages Workbook and Worksheets for detailed examples:

Dim oMyWorkbook, oMyWorksheets
Set oMyWorkbook = CreateExcelWorkbook()
Set oMyWorksheets = oMyWorkbook.Worksheets
Call MsgBox(oMyWorksheets.Count)

oMyWorkbook = dd.CreateExcelWorkbook() 
oMyWorksheets = oMyWorkbook.Worksheets 
print(oMyWorksheets.Count)