Class Sheets (Excel VBA)

A collection of all the sheets in the specified or active workbook.

The classes Application, Window and Workbook. give access to class Sheets

Dim shts as Sheets
Set shts = Charts

Methods

Add - Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.

Copy - Copies the sheet to another location in the workbook.

Delete - Deletes the object.

FillAcrossSheets - Copies a range to the same area on all other worksheets in a collection.

Move - Moves the sheet to another location in the workbook.

PrintOut - Prints the object.

PrintPreview - Shows a preview of the object as it would look when printed.

Select - Selects the object.

Add - Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.

Copy - Copies the sheet to another location in the workbook.

Delete - Deletes the object.

FillAcrossSheets - Copies a range to the same area on all other worksheets in a collection.

Move - Moves the sheet to another location in the workbook.

PrintOut - Prints the object.

PrintPreview - Shows a preview of the object as it would look when printed.

Select - Selects the object.

Properties

Item (Default member) - Returns a single Object object from the collection. Item (Default member) - Returns a single Object object from the collection.

Count returns a Long value that represents the number of objects in the collection.

HPageBreaks returns an HPageBreaks collection that represents the horizontal page breaks on the sheet.

Parent returns the parent object for the specified object. Read-only.

Visible returns or sets a Variant value that determines whether the boolean is visible.

VPageBreaks returns a VPageBreaks collection that represents the vertical page breaks on the sheet.

Count returns a Long value that represents the number of objects in the collection.

HPageBreaks returns an HPageBreaks collection that represents the horizontal page breaks on the sheet.

Parent returns the parent object for the specified object. Read-only.

Visible returns or sets a Variant value that determines whether the boolean is visible.

VPageBreaks returns a VPageBreaks collection that represents the vertical page breaks on the sheet.