Search notes:

Office Object Model: Excel - Sheets

Sheets is a collection of all sheets (such as a worksheet objects).
Mulitple collection types are, in fact, sheets:
? typename(thisWorkbook.worksheets)
Sheets
? typename(charts)
Sheets
… etc …

Methods and properties

add()
add2() Only implemented in the charts collection.
application
copy()
count
creator
delete()
fillAcrossSheets() Copies a range to the same area on all other worksheets of the collection
hPageBreaks
item
move()
parent
printOut()
printPreview()
select()
visible
VPageBreaks

Sheet types

There are multiple sheet types in Excel which are enumerated by xlSheetType with the following values:
xlChart -4109 Chart
xlDialogSheet -4116 Dialog sheet
xlExcel4IntlMacroSheet 4 Excel version 4 international macro sheet
xlExcel4MacroSheet 3 Excel version 4 macro sheet
xlWorksheet -4167 of which one is the Worksheet
Since there are different types of sheets, there is also a Worksheets collection.

See also

The Worksheets collection
Excel Object Model

Index