Export (0) Print
Expand All

Sheets Object Members

Office 2007

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

Methods

 NameDescription
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

 NameDescription
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.


Community Additions

ADD
Show:
© 2015 Microsoft