Sheets
is a collection of all sheets (such as a worksheet
objects). sheets
: ? typename(thisWorkbook.worksheets) Sheets ? typename(charts) Sheets … etc …
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 |
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 |
Worksheets
collection.