Worksheets Members

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

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

  Name Description
Public property _Default  
Public property Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Public property Count Returns the number of objects in the collection. Read-only Integer.
Public property 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.
Public property HPageBreaks Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only.
Public property Item Returns a single object from a collection.
Public property Parent Returns the parent object for the specified object. Read-only.
Public property Visible Determines whether the object is visible. Read/write Object.
Public property VPageBreaks Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only.

  Name Description
Public method _PrintOut  
Public method Add Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.
Public method Copy Copies the sheet to another location in the workbook.
Public method Delete Deletes the object.
Public method FillAcrossSheets Copies a range to the same area on all other worksheets in a collection.
Public method GetEnumerator  
Public method Move Moves the sheet to another location in the workbook.
Public method PrintOut Prints the object.
Public method PrintOutEx  
Public method PrintPreview Shows a preview of the object as it would look when printed.
Public method Select Selects the object.

Community Additions