Share via

Sheets Object Members

  • Article
Excel Developer Reference

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

Methods

  Name Description
Bb225674.methods(en-us,office.12).gif Add Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.
Bb225674.methods(en-us,office.12).gif Copy Copies the sheet to another location in the workbook.
Bb225674.methods(en-us,office.12).gif Delete Deletes the object.
Bb225674.methods(en-us,office.12).gif FillAcrossSheets Copies a range to the same area on all other worksheets in a collection.
Bb225674.methods(en-us,office.12).gif Move Moves the sheet to another location in the workbook.
Bb225674.methods(en-us,office.12).gif PrintOut Prints the object.
Bb225674.methods(en-us,office.12).gif PrintPreview Shows a preview of the object as it would look when printed.
Bb225674.methods(en-us,office.12).gif Select Selects the object.

Properties

  Name Description
Bb225674.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb225674.properties(en-us,office.12).gif Count Returns a Long value that represents the number of objects in the collection.
Bb225674.properties(en-us,office.12).gif HPageBreaks Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only.
Bb225674.properties(en-us,office.12).gif Item Returns a single object from a collection.
Bb225674.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225674.properties(en-us,office.12).gif Visible Returns or sets a Variant value that determines whether the object is visible.
Bb225674.properties(en-us,office.12).gif VPageBreaks Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only.