Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Worksheets Members
Collapse the table of content
Expand the table of content

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