Worksheet properties

	Name	Description
	_CodeName	Reserved for internal use. (Inherited from _Worksheet.)
	_DisplayRightToLeft	Reserved for internal use. (Inherited from _Worksheet.)
	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. (Inherited from _Worksheet.)
	AutoFilter	Returns an AutoFilter object if filtering is on. Returns Nothing if filtering is off. Read-only. (Inherited from _Worksheet.)
	AutoFilterMode	True if the AutoFilter drop-down arrows are currently displayed on the sheet. This property is independent of the FilterMode property. Read/write Boolean. (Inherited from _Worksheet.)
	Cells	Returns a Range object that represents all the cells on the worksheet (not just the cells that are currently in use). Read-only. (Inherited from _Worksheet.)
	CircularReference	Returns a Range object that represents the range containing the first circular reference on the sheet, or returns Nothing if there's no circular reference on the sheet. The circular reference must be removed before calculation can proceed. Read-only. (Inherited from _Worksheet.)
	CodeName	Returns the code name for the object. Read-only String. (Inherited from _Worksheet.)
	Columns	Returns a Range object that represents all the columns on the specified worksheet. Read-only. (Inherited from _Worksheet.)
	Comments	Returns a Comments collection that represents all the comments for the specified worksheet. Read-only. (Inherited from _Worksheet.)
	ConsolidationFunction	Returns the function code used for the current consolidation. Can be one of the XlConsolidationFunction constants. Read-only. (Inherited from _Worksheet.)
	ConsolidationOptions	Returns a three-element array of consolidation options, as shown in the following table. If the element is True, that option is set. Read-only Object. (Inherited from _Worksheet.)
	ConsolidationSources	Returns an array of string values that name the source sheets for the worksheet's current consolidation. Returns Empty if there's no consolidation on the sheet. Read-only Object. (Inherited from _Worksheet.)
	Creator	Returns a constant in the XlCreator enumeration 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 xlCreatorCode. (Inherited from _Worksheet.)
	CustomProperties	Returns a CustomProperties object representing the identifier information associated with a worksheet. (Inherited from _Worksheet.)
	DisplayAutomaticPageBreaks	Reserved for internal use. (Inherited from _Worksheet.)
	DisplayPageBreaks	True if page breaks (both automatic and manual) on the specified worksheet are displayed. Read/write Boolean. (Inherited from _Worksheet.)
	DisplayRightToLeft	True if the specified window, worksheet, or ListObject is displayed from right to left instead of from left to right. False if the object is displayed from left to right. Read-only Boolean. (Inherited from _Worksheet.)
	EnableAutoFilter	True if AutoFilter arrows are enabled when user-interface-only protection is turned on. Read/write Boolean. (Inherited from _Worksheet.)
	EnableCalculation	True if Microsoft Excel automatically recalculates the worksheet when necessary. False if Excel doesn't recalculate the sheet. Read/write Boolean. (Inherited from _Worksheet.)
	EnableFormatConditionsCalculation	Returns or sets if conditional formats will occur automatically as needed. Read/write Boolean. (Inherited from _Worksheet.)
	EnableOutlining	True if outlining symbols are enabled when user-interface-only protection is turned on. Read/write Boolean. (Inherited from _Worksheet.)
	EnablePivotTable	True if PivotTable controls and actions are enabled when user-interface-only protection is turned on. Read/write Boolean. (Inherited from _Worksheet.)
	EnableSelection	Returns or sets what can be selected on the sheet. Read/write XlEnableSelection. (Inherited from _Worksheet.)
	FilterMode	True if the worksheet is in filter mode. Read-only Boolean. (Inherited from _Worksheet.)
	HPageBreaks	Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only. (Inherited from _Worksheet.)
	Hyperlinks	Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet. (Inherited from _Worksheet.)
	Index	Returns the index number of the object within the collection of similar objects. Read-only Integer. (Inherited from _Worksheet.)
	ListObjects	Returns a collection of ListObject objects in the worksheet. Read-only ListObjects collection. (Inherited from _Worksheet.)
	MailEnvelope	Represents an e-mail header for a document. (Inherited from _Worksheet.)
	Name	Returns or sets the name of the object. Read/write String. (Inherited from _Worksheet.)
	Names	Returns a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). Read-only Names object. (Inherited from _Worksheet.)
	Next	Returns a Chart, Range, or Worksheet object that represents the next sheet or cell. Read-only. (Inherited from _Worksheet.)
	OnCalculate	Reserved for internal use. (Inherited from _Worksheet.)
	OnData	Reserved for internal use. (Inherited from _Worksheet.)
	OnDoubleClick	Reserved for internal use. (Inherited from _Worksheet.)
	OnEntry	Reserved for internal use. (Inherited from _Worksheet.)
	OnSheetActivate	Reserved for internal use. (Inherited from _Worksheet.)
	OnSheetDeactivate	Reserved for internal use. (Inherited from _Worksheet.)
	Outline	Returns an Outline object that represents the outline for the specified worksheet. Read-only. (Inherited from _Worksheet.)
	PageSetup	Returns a PageSetup object that contains all the page setup settings for the specified object. Read-only. (Inherited from _Worksheet.)
	Parent	Returns the parent object for the specified object. Read-only. (Inherited from _Worksheet.)
	Previous	Returns a Chart, Range, or Worksheet object that represents the previous sheet or cell. Read-only. (Inherited from _Worksheet.)
	PrintedCommentPages	Gets the number of comment pages that will be printed for the current worksheet. (Inherited from _Worksheet.)
	ProtectContents	True if the contents of the sheet are protected. For a chart, this protects the entire chart. For a worksheet, this protects the individual cells. Read-only Boolean. (Inherited from _Worksheet.)
	ProtectDrawingObjects	True if shapes are protected. Read-only Boolean. (Inherited from _Worksheet.)
	Protection	Returns a Protection object that represents the protection options of the worksheet. (Inherited from _Worksheet.)
	ProtectionMode	True if user-interface-only protection is turned on. To turn on user interface protection, use the Protect method with the UserInterfaceOnly argument set to True. Read-only Boolean. (Inherited from _Worksheet.)
	ProtectScenarios	True if the worksheet scenarios are protected. Read-only Boolean. (Inherited from _Worksheet.)
	QueryTables	Returns the QueryTables collection that represents all the query tables on the specified worksheet. Read-only. (Inherited from _Worksheet.)
	Range	Returns a Range object that represents a cell or a range of cells. (Inherited from _Worksheet.)
	Rows	Returns a Range object that represents all the rows on the specified worksheet. Read-only Range object. (Inherited from _Worksheet.)
	Scripts	Returns the Scripts collection, which contains Script objects representing blocks of script or code in the specified document when it’s saved as a Web page. (Inherited from _Worksheet.)
	ScrollArea	Returns or sets the range where scrolling is allowed as an A1-style range reference. Cells outside the scroll area cannot be selected. Read/write String. (Inherited from _Worksheet.)
	Shapes	Returns a Shapes object that represents all the shapes on the worksheet or chart sheet. Read-only. (Inherited from _Worksheet.)
	SmartTags	Returns a SmartTags object representing the identifier for the specified cell. (Inherited from _Worksheet.)
	Sort	Returns the sorted values in the current worksheet. Read-only. (Inherited from _Worksheet.)
	StandardHeight	Returns the standard (default) height of all the rows in the worksheet in points. Read-only Double. (Inherited from _Worksheet.)
	StandardWidth	Returns or sets the standard (default) width of all the columns in the worksheet. Read/write Double. (Inherited from _Worksheet.)
	Tab	Returns a Tab object for a chart or a worksheet. (Inherited from _Worksheet.)
	TransitionExpEval	True if Microsoft Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet. Read/write Boolean. (Inherited from _Worksheet.)
	TransitionFormEntry	True if Microsoft Excel uses Lotus 1-2-3 formula entry rules for the worksheet. Read/write Boolean. (Inherited from _Worksheet.)
	Type	Returns or sets the worksheet type. Read-only XlSheetType. (Inherited from _Worksheet.)
	UsedRange	Returns a Range object that represents the used range on the specified worksheet. Read-only. (Inherited from _Worksheet.)
	Visible	Determines whether the object is visible. Read/write XlSheetVisibility. (Inherited from _Worksheet.)
	VPageBreaks	Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only. (Inherited from _Worksheet.)

Top

Reference