Export (0) Print
Expand All

Sheets Members 

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

The following tables list the members exposed by the Sheets type.

  Name Description
Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Count Returns the number of objects in the collection. Read-only Integer.
Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
HPageBreaks Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only.
Item Returns a single object from a collection.
Parent Returns the parent object for the specified object. Read-only.
Visible Determines whether the object is visible. Read/write Object.
VPageBreaks Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only.

  Name Description
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.
GetEnumerator Returns an enumerator to support iterating through the 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

Community Additions

© 2015 Microsoft