Export (0) Print
Expand All

Worksheets Object Members

Office 2007

A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

Methods

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

Properties

 NameDescription
Bb225776.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.
Bb225776.properties(en-us,office.12).gif Count Returns a Long value that represents the number of objects in the collection.
Bb225776.properties(en-us,office.12).gif HPageBreaks Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only.
Bb225776.properties(en-us,office.12).gif Item Returns a single object from a collection.
Bb225776.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225776.properties(en-us,office.12).gif Visible Returns or sets a Variant value that determines whether the object is visible.
Bb225776.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:
© 2014 Microsoft