ÿþ<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><script> function getHelp(link) { window.open("http://" + location.hostname + "/Explorer/" + link, "_help", "left=400,resizable=yes,toolbar=yes,width=200,height=200,scrollbars=yes").focus(); } function showReturns(returns) { window.status = returns; } </script><head> <!--[if gte mso 9]><xml> <mso:CustomDocumentProperties> <mso:Order msdt:dt="string">349000.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>Chapter 09</title> <!--mstheme--><link rel="stylesheet" type="text/css" id="onetidThemeCSS" href="../_themes/simple/simp1011-1200.css"><meta name="Microsoft Theme" content="simple 1011, default"> </head><body> <H1>Excel Range Objects</H1> <h2>AllowEditRange (2002) <img src="MSGBOX02.ICO" alt="Represents the cells that can be edited on a protected worksheet." width="16" height="16" onclick="getHelp('xlobjAllowEditRange.htm');showMozHelp('Represents the cells that can be edited on a protected worksheet.');"></h2>ChangePassword(Password) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the password for a range that can be edited on a protected worksheet." width="16" height="16" onclick="getHelp('xlmthChangePassword.htm')" onmouseover="showReturns('Returns: Void')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Range [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>Title [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the title of the Web page when the document is saved as a Web page. Read/write String." width="16" height="16" onclick="getHelp('xlproTitle.htm')" onmouseover="showReturns('Returns: String')"><br>Unprotect([Password]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected." width="16" height="16" onclick="getHelp('xlmthUnprotect.htm')" onmouseover="showReturns('Returns: Void')"><br>Users<input type="image" src="MSGBOX02.ICO" alt="Returns: UserAccessList. Returns a UserAccessList object for the protected range on a worksheet." width="16" height="16" onclick="getHelp('xlproUsers.htm')" onmouseover="showReturns('Returns: UserAccessList')"><br><h2>AllowEditRanges (2002) <img src="MSGBOX02.ICO" alt="A collection of all the AllowEditRanges objects that represent the cells that can be edited on a protected worksheet." width="16" height="16" onclick="getHelp('xlobjAllowEditRanges.htm');showMozHelp('A collection of all the AllowEditRanges objects that represent the cells that can be edited on a protected worksheet.');"></h2>Add(Title, Range, [Password]) <input type="image" src="MSGBOX02.ICO" alt="Returns: AllowEditRange. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: AllowEditRange')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: AllowEditRange. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: AllowEditRange')"><br><h2>Areas (1995) <img src="MSGBOX02.ICO" alt="A collection of the areas, or contiguous blocks of cells, within a selection. Theres no singular Area object; individual members of the Areas collection are Range objects. The Areas collection contains one Range object for each discrete, contiguous range of cells within the selection. If the selection contains only one area, the Areas collection contains a single Range object that corresponds to that selection." width="16" height="16" onclick="getHelp('xlobjAreas.htm');showMozHelp('A collection of the areas, or contiguous blocks of cells, within a selection. Theres no singular Area object; individual members of the Areas collection are Range objects. The Areas collection contains one Range object for each discrete, contiguous range of cells within the selection. If the selection contains only one area, the Areas collection contains a single Range object that corresponds to that selection.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Range')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>AutoFilter (1995) <img src="MSGBOX02.ICO" alt="Represents autofiltering for the specified worksheet." width="16" height="16" onclick="getHelp('xlobjAutoFilter.htm');showMozHelp('Represents autofiltering for the specified worksheet.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Filters<input type="image" src="MSGBOX02.ICO" alt="Returns: Filters. Returns a Filters collection that represents all the filters in an autofiltered range. Read-only." width="16" height="16" onclick="getHelp('xlproFilters.htm')" onmouseover="showReturns('Returns: Filters')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br><h2>Characters (1995) <img src="MSGBOX02.ICO" alt="Represents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string." width="16" height="16" onclick="getHelp('xlobjCharacters.htm');showMozHelp('Represents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption property and related properties, given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Insert(String) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space." width="16" height="16" onclick="getHelp('xlmthInsert.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PhoneticCharacters [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the phonetic text in the specified Characters object. Read/write String." width="16" height="16" onclick="getHelp('xlproPhoneticCharacters.htm')" onmouseover="showReturns('Returns: String')"><br>Text [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects." width="16" height="16" onclick="getHelp('xlproText.htm')" onmouseover="showReturns('Returns: String')"><br><h2>DocEvents (1997) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforeDoubleClick(Target, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforeRightClick(Target, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Calculate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table." width="16" height="16" onclick="getHelp('xlmthCalculate.htm')" onmouseover="showReturns('Returns: Void')"><br>Change(Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Deactivate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>FollowHyperlink(Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Displays a cached document, if its already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application." width="16" height="16" onclick="getHelp('xlmthFollowHyperlink.htm')" onmouseover="showReturns('Returns: Void')"><br>PivotTableUpdate(Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SelectionChange(Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>Error (2002) <img src="MSGBOX02.ICO" alt="Represents a spreadsheet error for a range." width="16" height="16" onclick="getHelp('xlobjError.htm');showMozHelp('Represents a spreadsheet error for a range.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Ignore [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Allows the user to set or return the state of an error checking option for a range. False enables an error checking option for a range. True disables an error checking option for a range. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIgnore.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Value<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Errors (2002) <img src="MSGBOX02.ICO" alt="Represents the various spreadsheet errors for a range." width="16" height="16" onclick="getHelp('xlobjErrors.htm');showMozHelp('Represents the various spreadsheet errors for a range.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Error. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Error')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Font (2000) <img src="MSGBOX02.ICO" alt="Contains the font attributes (font name, font size, color, and so on) for an object." width="16" height="16" onclick="getHelp('xlobjFont.htm');showMozHelp('Contains the font attributes (font name, font size, color, and so on) for an object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Background [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns a Shape object that represents the background image for the specified document. Read-only." width="16" height="16" onclick="getHelp('xlproBackground.htm')" onmouseover="showReturns('Returns: Object')"><br>Bold [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font is bold. Read/write Variant." width="16" height="16" onclick="getHelp('xlproBold.htm')" onmouseover="showReturns('Returns: Object')"><br>Color [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the color of the tick-mark labels on the value axis in Chart1." width="16" height="16" onclick="getHelp('xlproColor.htm')" onmouseover="showReturns('Returns: Object')"><br>ColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The following examples assume that you're using the default color palette." width="16" height="16" onclick="getHelp('xlproColorIndex.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>FontStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the font style. Read/write String." width="16" height="16" onclick="getHelp('xlproFontStyle.htm')" onmouseover="showReturns('Returns: Object')"><br>Italic [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font style is italic. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproItalic.htm')" onmouseover="showReturns('Returns: Object')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: Object')"><br>OutlineFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font is an outline font. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproOutlineFont.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Shadow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: Object')"><br>Size [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the size of the font. Read/write Variant." width="16" height="16" onclick="getHelp('xlproSize.htm')" onmouseover="showReturns('Returns: Object')"><br>Strikethrough [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font is struck through with a horizontal line. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproStrikethrough.htm')" onmouseover="showReturns('Returns: Object')"><br>Subscript [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font is formatted as subscript. False by default. Read/write Variant." width="16" height="16" onclick="getHelp('xlproSubscript.htm')" onmouseover="showReturns('Returns: Object')"><br>Superscript [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the font is formatted as superscript; False by default. Read/write Variant." width="16" height="16" onclick="getHelp('xlproSuperscript.htm')" onmouseover="showReturns('Returns: Object')"><br>Underline [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. " width="16" height="16" onclick="getHelp('xlproUnderline.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>FormatCondition (1997) <img src="MSGBOX02.ICO" alt="Represents a conditional format. The FormatCondition object is a member of the FormatConditions collection. The FormatConditions collection can contain up to three conditional formats for a given range." width="16" height="16" onclick="getHelp('xlobjFormatCondition.htm');showMozHelp('Represents a conditional format. The FormatCondition object is a member of the FormatConditions collection. The FormatConditions collection can contain up to three conditional formats for a given range.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Borders<input type="image" src="MSGBOX02.ICO" alt="Returns: Borders. For information about returning a single member of a collection, see Returning an Object from a Collection." width="16" height="16" onclick="getHelp('xlproBorders.htm')" onmouseover="showReturns('Returns: Borders')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Formula1<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. Read-only String." width="16" height="16" onclick="getHelp('xlproFormula1.htm')" onmouseover="showReturns('Returns: String')"><br>Formula2<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the value or expression associated with the second part of a conditional format or data validation. Used only when the data validation conditional format Operator property is xlBetween or xlNotBetween. Can be a constant value, a string value, a cell reference, or a formula. Read-only String." width="16" height="16" onclick="getHelp('xlproFormula2.htm')" onmouseover="showReturns('Returns: String')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Modify(Type, [Operator], [Formula1], [Formula2]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Modifies the data validation or conditional format. For more information, click the object you want to modify." width="16" height="16" onclick="getHelp('xlmthModify.htm')" onmouseover="showReturns('Returns: Void')"><br>Operator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example changes the formula for conditional format one, for cells E1:E10 if the formula specifies &amp;quot;less than 5.&amp;quot;" width="16" height="16" onclick="getHelp('xlproOperator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>FormatConditions (1997) <img src="MSGBOX02.ICO" alt="Represents the collection of conditional formats for a single range. The FormatConditions collection can contain up to three conditional formats. Each format is represented by a FormatCondition object." width="16" height="16" onclick="getHelp('xlobjFormatConditions.htm');showMozHelp('Represents the collection of conditional formats for a single range. The FormatConditions collection can contain up to three conditional formats. Each format is represented by a FormatCondition object.');"></h2>Add(Type, [Operator], [Formula1], [Formula2]) <input type="image" src="MSGBOX02.ICO" alt="Returns: FormatCondition. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: FormatCondition')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: FormatCondition. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: FormatCondition')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Name (1995) <img src="MSGBOX02.ICO" alt="Represents a defined name for a range of cells. Names can be either built-in names&amp;nbsp; such as Database, Print_Area, and Auto_Open&amp;nbsp; or custom names." width="16" height="16" onclick="getHelp('xlobjName.htm');showMozHelp('Represents a defined name for a range of cells. Names can be either built-in names&amp;nbsp; such as Database, Print_Area, and Auto_Open&amp;nbsp; or custom names.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Category [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the category for the specified name in the language of the macro. The name must refer to a custom function or command. Read/write String." width="16" height="16" onclick="getHelp('xlproCategory.htm')" onmouseover="showReturns('Returns: String')"><br>CategoryLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the category for the specified name, in the language of the user, if the name refers to a custom function or command. Read/write String." width="16" height="16" onclick="getHelp('xlproCategoryLocal.htm')" onmouseover="showReturns('Returns: String')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>MacroType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlXLMMacroType. This example assumes that you created a custom function or command on a Microsoft Excel version 4.0 macro sheet. The example displays the function category, in the language of the macro. It assumes that the name of the custom function or command is the only name in the workbook." width="16" height="16" onclick="getHelp('xlproMacroType.htm')" onmouseover="showReturns('Returns: XlXLMMacroType')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>NameLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the object, in the language of the user. Read/write String for Name, read-only String for Style." width="16" height="16" onclick="getHelp('xlproNameLocal.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>RefersTo [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula that the name is defined to refer to, in the language of the macro and in A1-style notation, beginning with an equal sign. Read/write String." width="16" height="16" onclick="getHelp('xlproRefersTo.htm')" onmouseover="showReturns('Returns: Object')"><br>RefersToLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula that the name refers to. The formula is in the language of the user, and it's in A1-style notation, beginning with an equal sign. Read/write String." width="16" height="16" onclick="getHelp('xlproRefersToLocal.htm')" onmouseover="showReturns('Returns: Object')"><br>RefersToR1C1 [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula that the name refers to. The formula is in the language of the macro, and it's in R1C1-style notation, beginning with an equal sign. Read/write String." width="16" height="16" onclick="getHelp('xlproRefersToR1C1.htm')" onmouseover="showReturns('Returns: Object')"><br>RefersToR1C1Local [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula that the name refers to. This formula is in the language of the user, and it's in R1C1-style notation, beginning with an equal sign. Read/write String." width="16" height="16" onclick="getHelp('xlproRefersToR1C1Local.htm')" onmouseover="showReturns('Returns: Object')"><br>RefersToRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns the Range object referred to by a Name object. Read-only." width="16" height="16" onclick="getHelp('xlproRefersToRange.htm')" onmouseover="showReturns('Returns: Range')"><br>ShortcutKey [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the shortcut key for a name defined as a custom Microsoft Excel 4.0 macro command. Read/write String." width="16" height="16" onclick="getHelp('xlproShortcutKey.htm')" onmouseover="showReturns('Returns: String')"><br>Value [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: String')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Names (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names&amp;nbsp; such as Database, Print_Area, and Auto_Open&amp;nbsp; or custom names." width="16" height="16" onclick="getHelp('xlobjNames.htm');showMozHelp('A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names&amp;nbsp; such as Database, Print_Area, and Auto_Open&amp;nbsp; or custom names.');"></h2>Add([Name], [RefersTo], [Visible], [MacroType], [ShortcutKey], [Category], [NameLocal], [RefersToLocal], [CategoryLocal], [RefersToR1C1], [RefersToR1C1Local]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Name. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Name')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item([Index], [IndexLocal], [RefersTo]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Name. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Name')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Outline (1995) <img src="MSGBOX02.ICO" alt="Represents an outline on a worksheet." width="16" height="16" onclick="getHelp('xlobjOutline.htm');showMozHelp('Represents an outline on a worksheet.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutomaticStyles [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the outline uses automatic styles. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutomaticStyles.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>ShowLevels([RowLevels], [ColumnLevels]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays the specified number of row and/or column levels of an outline." width="16" height="16" onclick="getHelp('xlmthShowLevels.htm')" onmouseover="showReturns('Returns: Object')"><br>SummaryColumn [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSummaryColumn. This example creates an outline with automatic styles, with the summary row above the detail rows, and with the summary column to the right of the detail columns." width="16" height="16" onclick="getHelp('xlproSummaryColumn.htm')" onmouseover="showReturns('Returns: XlSummaryColumn')"><br>SummaryRow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSummaryRow. Set SummaryRow to xlAbove for Microsoft Word-style outlines, where category headers are above the detailed information. Set SummaryRow to xlBelow for accounting-style outlines, where summations are below the detailed information." width="16" height="16" onclick="getHelp('xlproSummaryRow.htm')" onmouseover="showReturns('Returns: XlSummaryRow')"><br><h2>Phonetic (2000) <img src="MSGBOX02.ICO" alt="Contains information about a specific phonetic text string in a cell. In Microsoft Excel 97, this object contained the formatting attributes for any phonetic text in the specified range." width="16" height="16" onclick="getHelp('xlobjPhonetic.htm');showMozHelp('Contains information about a specific phonetic text string in a cell. In Microsoft Excel 97, this object contained the formatting attributes for any phonetic text in the specified range.');"></h2>Alignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. " width="16" height="16" onclick="getHelp('xlproAlignment.htm')" onmouseover="showReturns('Returns: Int32')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>CharacterType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example changes the first phonetic text string in the active cell from Furigana to Hiragana." width="16" height="16" onclick="getHelp('xlproCharacterType.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Text [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects." width="16" height="16" onclick="getHelp('xlproText.htm')" onmouseover="showReturns('Returns: String')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Phonetics (2000) <img src="MSGBOX02.ICO" alt="A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string." width="16" height="16" onclick="getHelp('xlobjPhonetics.htm');showMozHelp('A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.');"></h2>Add(Start, Length, Text) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Void')"><br>Alignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. " width="16" height="16" onclick="getHelp('xlproAlignment.htm')" onmouseover="showReturns('Returns: Int32')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>CharacterType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example changes the first phonetic text string in the active cell from Furigana to Hiragana." width="16" height="16" onclick="getHelp('xlproCharacterType.htm')" onmouseover="showReturns('Returns: Int32')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Object')"><br>Length<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This property is read-only. Use the CustomLength method to set the value of this property for a CalloutFormat object." width="16" height="16" onclick="getHelp('xlproLength.htm')" onmouseover="showReturns('Returns: Int32')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Start<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the position that represents the first character of a phonetic text string in the specified cell. Read-only Long." width="16" height="16" onclick="getHelp('xlproStart.htm')" onmouseover="showReturns('Returns: Int32')"><br>Text [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects." width="16" height="16" onclick="getHelp('xlproText.htm')" onmouseover="showReturns('Returns: String')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Protection (2002) <img src="MSGBOX02.ICO" alt="Represents the various types of protection options available for a worksheet." width="16" height="16" onclick="getHelp('xlobjProtection.htm');showMozHelp('Represents the various types of protection options available for a worksheet.');"></h2>AllowDeletingColumns<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the deletion of columns is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowDeletingColumns.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowDeletingRows<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the deletion of rows is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowDeletingRows.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowEditRanges<input type="image" src="MSGBOX02.ICO" alt="Returns: AllowEditRanges. Returns an AllowEditRanges object." width="16" height="16" onclick="getHelp('xlproAllowEditRanges.htm')" onmouseover="showReturns('Returns: AllowEditRanges')"><br>AllowFiltering<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the user is allowed to make use of an AutoFilter that was created before the sheet was protected. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowFiltering.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowFormattingCells<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the formatting of cells is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowFormattingCells.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowFormattingColumns<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the formatting of columns is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowFormattingColumns.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowFormattingRows<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the formatting of rows is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowFormattingRows.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowInsertingColumns<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the insertion of columns is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowInsertingColumns.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowInsertingHyperlinks<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the insertion of hyperlinks is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowInsertingHyperlinks.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowInsertingRows<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the insertion of rows is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowInsertingRows.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowSorting<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the sorting option is allowed on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowSorting.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AllowUsingPivotTables<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the user is allowed to manipulate pivot tables on a protected worksheet. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAllowUsingPivotTables.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Range (1995) <img src="MSGBOX02.ICO" alt="Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range." width="16" height="16" onclick="getHelp('xlobjRange.htm');showMozHelp('Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.');"></h2>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.htm')" onmouseover="showReturns('Returns: Object')"><br>AddComment([Text]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Comment. Adds a comment to the range." width="16" height="16" onclick="getHelp('xlmthAddComment.htm')" onmouseover="showReturns('Returns: Comment')"><br>AddIndent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To set text alignment to equal distribution, you can set the HorizontalAlignment property to xlHAlignDistributed when the value of the Orientation property is xlHorizontal." width="16" height="16" onclick="getHelp('xlproAddIndent.htm')" onmouseover="showReturns('Returns: Object')"><br>Address<input type="image" src="MSGBOX02.ICO" alt="Returns: String. If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and columns." width="16" height="16" onclick="getHelp('xlproAddress.htm')" onmouseover="showReturns('Returns: String')"><br>AddressLocal<input type="image" src="MSGBOX02.ICO" alt="Returns: String. If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and all columns, respectively." width="16" height="16" onclick="getHelp('xlproAddressLocal.htm')" onmouseover="showReturns('Returns: String')"><br>AdvancedFilter(Action, [CriteriaRange], [CopyToRange], [Unique]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Filters or copies data from a list based on a criteria range. If the initial selection is a single cell, that cell's current region is used.&amp;nbsp; Variant." width="16" height="16" onclick="getHelp('xlmthAdvancedFilter.htm')" onmouseover="showReturns('Returns: Object')"><br>AllowEdit<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. In this example, Microsoft Excel notifies the user if cell A1 can be edited or not on a protected worksheet." width="16" height="16" onclick="getHelp('xlproAllowEdit.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>ApplyNames([Names], [IgnoreRelativeAbsolute], [UseRowColumnNames], [OmitColumn], [OmitRow], [Order], [AppendLast]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Applies names to the cells in the specified range." width="16" height="16" onclick="getHelp('xlmthApplyNames.htm')" onmouseover="showReturns('Returns: Object')"><br>ApplyOutlineStyles() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Applies outlining styles to the specified range." width="16" height="16" onclick="getHelp('xlmthApplyOutlineStyles.htm')" onmouseover="showReturns('Returns: Object')"><br>Areas<input type="image" src="MSGBOX02.ICO" alt="Returns: Areas. Returns an Areas collection that represents all the ranges in a multiple-area selection. Read-only." width="16" height="16" onclick="getHelp('xlproAreas.htm')" onmouseover="showReturns('Returns: Areas')"><br>AutoComplete(String) <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns an AutoComplete match from the list. If theres no AutoComplete match or if more than one entry in the list matches the string to complete, this method returns an empty string." width="16" height="16" onclick="getHelp('xlmthAutoComplete.htm')" onmouseover="showReturns('Returns: String')"><br>AutoFill(Destination, [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Performs an autofill on the cells in the specified range. Variant." width="16" height="16" onclick="getHelp('xlmthAutoFill.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoFilter([Field], [Criteria1], [Operator], [Criteria2], [VisibleDropDown]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Filters a list using the AutoFilter. Variant." width="16" height="16" onclick="getHelp('xlmthAutoFilter.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoFit() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit." width="16" height="16" onclick="getHelp('xlmthAutoFit.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoFormat([Format], [Number], [Font], [Alignment], [Border], [Pattern], [Width]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Automatically formats the specified range, using a predefined format." width="16" height="16" onclick="getHelp('xlmthAutoFormat.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoOutline() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Automatically creates an outline for the specified range. If the range is a single cell, Microsoft Excel creates an outline for the entire sheet. The new outline replaces any existing outline." width="16" height="16" onclick="getHelp('xlmthAutoOutline.htm')" onmouseover="showReturns('Returns: Object')"><br>BorderAround([LineStyle], [Weight], [ColorIndex], [Color]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. You must specify either ColorIndex or Color, but not both." width="16" height="16" onclick="getHelp('xlmthBorderAround.htm')" onmouseover="showReturns('Returns: Object')"><br>Borders<input type="image" src="MSGBOX02.ICO" alt="Returns: Borders. For information about returning a single member of a collection, see Returning an Object from a Collection." width="16" height="16" onclick="getHelp('xlproBorders.htm')" onmouseover="showReturns('Returns: Borders')"><br>Calculate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table." width="16" height="16" onclick="getHelp('xlmthCalculate.htm')" onmouseover="showReturns('Returns: Object')"><br>Cells<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Because the default property for the Range object, you can specify the row and column index immediately after the Cells keyword. For more information, see the Item property and the examples for this topic." width="16" height="16" onclick="getHelp('xlproCells.htm')" onmouseover="showReturns('Returns: Range')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.htm')" onmouseover="showReturns('Returns: Object')"><br>Clear() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example clears the formulas and formatting in cells A1:G37 on Sheet1." width="16" height="16" onclick="getHelp('xlmthClear.htm')" onmouseover="showReturns('Returns: Object')"><br>ClearComments() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Clears all cell comments from the specified range." width="16" height="16" onclick="getHelp('xlmthClearComments.htm')" onmouseover="showReturns('Returns: Void')"><br>ClearContents() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formulas from the range. Clears the data from a chart but leaves the formatting." width="16" height="16" onclick="getHelp('xlmthClearContents.htm')" onmouseover="showReturns('Returns: Object')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>ClearNotes() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears notes and sound notes from all the cells in the specified range." width="16" height="16" onclick="getHelp('xlmthClearNotes.htm')" onmouseover="showReturns('Returns: Object')"><br>ClearOutline() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the outline for the specified range." width="16" height="16" onclick="getHelp('xlmthClearOutline.htm')" onmouseover="showReturns('Returns: Object')"><br>Column<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the number of the first column in the first area in the specified range. Read-only Long." width="16" height="16" onclick="getHelp('xlproColumn.htm')" onmouseover="showReturns('Returns: Int32')"><br>ColumnDifferences(Comparison) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents all the cells whose contents are different from the comparison cell in each column." width="16" height="16" onclick="getHelp('xlmthColumnDifferences.htm')" onmouseover="showReturns('Returns: Range')"><br>Columns<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. " width="16" height="16" onclick="getHelp('xlproColumns.htm')" onmouseover="showReturns('Returns: Range')"><br>ColumnWidth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the width of all columns in the specified range. Read/write Variant." width="16" height="16" onclick="getHelp('xlproColumnWidth.htm')" onmouseover="showReturns('Returns: Object')"><br>Comment<input type="image" src="MSGBOX02.ICO" alt="Returns: Comment. Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range. Read-only Comment object." width="16" height="16" onclick="getHelp('xlproComment.htm')" onmouseover="showReturns('Returns: Comment')"><br>Consolidate([Sources], [Function], [TopRow], [LeftColumn], [CreateLinks]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example consolidates data from Sheet2 and Sheet3 onto Sheet1, using the SUM function." width="16" height="16" onclick="getHelp('xlmthConsolidate.htm')" onmouseover="showReturns('Returns: Object')"><br>Copy([Destination]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Copies the range to the specified range or to the Clipboard." width="16" height="16" onclick="getHelp('xlmthCopy.htm')" onmouseover="showReturns('Returns: Object')"><br>CopyFromRecordset(Data, [MaxRows], [MaxColumns]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Copies the contents of an ADO or DAO Recordset object onto a worksheet, beginning at the upper-left corner of the specified range. If the Recordset object contains fields with OLE objects in them, this method fails." width="16" height="16" onclick="getHelp('xlmthCopyFromRecordset.htm')" onmouseover="showReturns('Returns: Int32')"><br>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.htm')" onmouseover="showReturns('Returns: Object')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>CreateNames([Top], [Left], [Bottom], [Right]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Creates names in the specified range, based on text labels in the sheet." width="16" height="16" onclick="getHelp('xlmthCreateNames.htm')" onmouseover="showReturns('Returns: Object')"><br>CreatePublisher([Edition], [Appearance], [ContainsPICT], [ContainsBIFF], [ContainsRTF], [ContainsVALU]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthCreatePublisher.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>CurrentArray<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only." width="16" height="16" onclick="getHelp('xlproCurrentArray.htm')" onmouseover="showReturns('Returns: Range')"><br>CurrentRegion<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. Read-only." width="16" height="16" onclick="getHelp('xlproCurrentRegion.htm')" onmouseover="showReturns('Returns: Range')"><br>Cut([Destination]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Object')"><br>DataSeries([Rowcol], [Type], [Date], [Step], [Stop], [Trend]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example creates a series of 12 dates. The series contains the last day of every month in 1996 and is created in the range A1:A12 on Sheet1." width="16" height="16" onclick="getHelp('xlmthDataSeries.htm')" onmouseover="showReturns('Returns: Object')"><br>Delete([Shift]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Dependents<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the range containing all the dependents of a cell. This can be a multiple selection (a union of Range objects) if theres more than one dependent. Read-only Range object." width="16" height="16" onclick="getHelp('xlproDependents.htm')" onmouseover="showReturns('Returns: Range')"><br>DialogBox() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays a dialog box defined by a dialog box definition table on a Microsoft Excel 4.0 macro sheet. Returns the number of the chosen control, or returns False if the user clicks the Cancel button." width="16" height="16" onclick="getHelp('xlmthDialogBox.htm')" onmouseover="showReturns('Returns: Object')"><br>DirectDependents<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the range containing all the direct dependents of a cell. This can be a multiple selection (a union of Range objects) if theres more than one dependent. Read-only Range object." width="16" height="16" onclick="getHelp('xlproDirectDependents.htm')" onmouseover="showReturns('Returns: Range')"><br>DirectPrecedents<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the range containing all the direct precedents of a cell. This can be a multiple selection (a union of Range objects) if theres more than one precedent. Read-only Range object." width="16" height="16" onclick="getHelp('xlproDirectPrecedents.htm')" onmouseover="showReturns('Returns: Range')"><br>Dirty() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Designates a range to be recalculated when the next recalculation occurs." width="16" height="16" onclick="getHelp('xlmthDirty.htm')" onmouseover="showReturns('Returns: Void')"><br>EditionOptions(Type, Option, [Name], [Reference], [Appearance], [ChartSize], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthEditionOptions.htm')" onmouseover="showReturns('Returns: Object')"><br>End<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. This example selects the cell at the top of column B in the region that contains cell B4." width="16" height="16" onclick="getHelp('xlproEnd.htm')" onmouseover="showReturns('Returns: Range')"><br>EntireColumn<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the entire column (or columns) that contains the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproEntireColumn.htm')" onmouseover="showReturns('Returns: Range')"><br>EntireRow<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproEntireRow.htm')" onmouseover="showReturns('Returns: Range')"><br>Errors<input type="image" src="MSGBOX02.ICO" alt="Returns: Errors. Allows the user to to access error checking options." width="16" height="16" onclick="getHelp('xlproErrors.htm')" onmouseover="showReturns('Returns: Errors')"><br>FillDown() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Fills down from the top cell or cells in the specified range to the bottom of the range. The contents and formatting of the cell or cells in the top row of a range are copied into the rest of the rows in the range." width="16" height="16" onclick="getHelp('xlmthFillDown.htm')" onmouseover="showReturns('Returns: Object')"><br>FillLeft() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Fills left from the rightmost cell or cells in the specified range. The contents and formatting of the cell or cells in the rightmost column of a range are copied into the rest of the columns in the range." width="16" height="16" onclick="getHelp('xlmthFillLeft.htm')" onmouseover="showReturns('Returns: Object')"><br>FillRight() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Fills right from the leftmost cell or cells in the specified range. The contents and formatting of the cell or cells in the leftmost column of a range are copied into the rest of the columns in the range." width="16" height="16" onclick="getHelp('xlmthFillRight.htm')" onmouseover="showReturns('Returns: Object')"><br>FillUp() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Fills up from the bottom cell or cells in the specified range to the top of the range. The contents and formatting of the cell or cells in the bottom row of a range are copied into the rest of the rows in the range." width="16" height="16" onclick="getHelp('xlmthFillUp.htm')" onmouseover="showReturns('Returns: Object')"><br>Find(What, [After], [LookIn], [LookAt], [SearchOrder], [SearchDirection], [MatchCase], [MatchByte], [SearchFormat]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. The settings for LookIn, LookAt, SearchOrder, and MatchByte are saved each time you use this method. If you dont specify values for these arguments the next time you call the method, the saved values are used. Setting these arguments changes the settings in the Find dialog box, and changing the settings in the Find dialog box changes the saved values that are used if you omit the arguments. To avoid problems, set these arguments explicitly each time you use this method." width="16" height="16" onclick="getHelp('xlmthFind.htm')" onmouseover="showReturns('Returns: Range')"><br>FindNext([After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Continues a search that was begun with the Range object that represents that cell. Doesnt affect the selection or the active cell." width="16" height="16" onclick="getHelp('xlmthFindNext.htm')" onmouseover="showReturns('Returns: Range')"><br>FindPrevious([After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Continues a search that was begun with the Range object that represents that cell. Doesnt affect the selection or the active cell." width="16" height="16" onclick="getHelp('xlmthFindPrevious.htm')" onmouseover="showReturns('Returns: Range')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>FormatConditions<input type="image" src="MSGBOX02.ICO" alt="Returns: FormatConditions. Returns a FormatConditions collection that represents all the conditional formats for the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproFormatConditions.htm')" onmouseover="showReturns('Returns: FormatConditions')"><br>Formula [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Formula property as it applies to the PivotField, PivotFormula, PivotItem, and Series objects." width="16" height="16" onclick="getHelp('xlproFormula.htm')" onmouseover="showReturns('Returns: Object')"><br>FormulaArray [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the array formula of a range. Returns (or can be set to) a single formula or a Visual Basic array. If the specified range doesn't contain an array formula, this property returns Null. Read/write Variant." width="16" height="16" onclick="getHelp('xlproFormulaArray.htm')" onmouseover="showReturns('Returns: Object')"><br>FormulaHidden [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. FormulaHidden property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproFormulaHidden.htm')" onmouseover="showReturns('Returns: Object')"><br>FormulaLabel [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlFormulaLabel. This example topic sets the AcceptLabelsInFormulas property and then sets cells B1:D1 to be column labels." width="16" height="16" onclick="getHelp('xlproFormulaLabel.htm')" onmouseover="showReturns('Returns: XlFormulaLabel')"><br>FormulaLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula for the object, using A1-style references in the language of the user. Read/write Variant for Range objects, read/write String for Series objects." width="16" height="16" onclick="getHelp('xlproFormulaLocal.htm')" onmouseover="showReturns('Returns: Object')"><br>FormulaR1C1 [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula for the object, using R1C1-style notation in the language of the macro. Read/write Variant for Range objects, read/write String for Series objects." width="16" height="16" onclick="getHelp('xlproFormulaR1C1.htm')" onmouseover="showReturns('Returns: Object')"><br>FormulaR1C1Local [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the formula for the object, using R1C1-style notation in the language of the user. Read/write Variant for Range objects, read/write String for Series objects." width="16" height="16" onclick="getHelp('xlproFormulaR1C1Local.htm')" onmouseover="showReturns('Returns: Object')"><br>FunctionWizard() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Starts the Function Wizard for the upper-left cell of the range." width="16" height="16" onclick="getHelp('xlmthFunctionWizard.htm')" onmouseover="showReturns('Returns: Object')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>GoalSeek(Goal, ChangingCell) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Calculates the values necessary to achieve a specific goal. If the goal is an amount returned by a formula, this calculates a value that, when supplied to your formula, causes the formula to return the number you want. Returns True if the goal seek is successful." width="16" height="16" onclick="getHelp('xlmthGoalSeek.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Group([Start], [End], [By], [Periods]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Groups the shapes in the specified range. Returns the grouped shapes as a single Shape object." width="16" height="16" onclick="getHelp('xlmthGroup.htm')" onmouseover="showReturns('Returns: Object')"><br>HasArray<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the specified cell is part of an array formula. Read-only Variant." width="16" height="16" onclick="getHelp('xlproHasArray.htm')" onmouseover="showReturns('Returns: Object')"><br>HasFormula<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if all cells in the range contain formulas; False if none of the cells in the range contains a formula; Null otherwise. Read-only Variant." width="16" height="16" onclick="getHelp('xlproHasFormula.htm')" onmouseover="showReturns('Returns: Object')"><br>Height<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Object')"><br>Hidden [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Don't confuse this property with the FormulaHidden property." width="16" height="16" onclick="getHelp('xlproHidden.htm')" onmouseover="showReturns('Returns: Object')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproHorizontalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br>Hyperlinks<input type="image" src="MSGBOX02.ICO" alt="Returns: Hyperlinks. Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet." width="16" height="16" onclick="getHelp('xlproHyperlinks.htm')" onmouseover="showReturns('Returns: Hyperlinks')"><br>ID [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the type for the specified object. Read-only Long." width="16" height="16" onclick="getHelp('xlproID.htm')" onmouseover="showReturns('Returns: String')"><br>IndentLevel [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. IndentLevel property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproIndentLevel.htm')" onmouseover="showReturns('Returns: Object')"><br>Insert([Shift], [CopyOrigin]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space." width="16" height="16" onclick="getHelp('xlmthInsert.htm')" onmouseover="showReturns('Returns: Object')"><br>InsertIndent(InsertAmount) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Adds an indent to the specified range." width="16" height="16" onclick="getHelp('xlmthInsertIndent.htm')" onmouseover="showReturns('Returns: Void')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Item [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Object')"><br>Justify() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Rearranges the text in a range so that it fills the range evenly." width="16" height="16" onclick="getHelp('xlmthJustify.htm')" onmouseover="showReturns('Returns: Object')"><br>Left<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Object')"><br>ListHeaderRows<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the number of header rows for the specified range. Read-only Long." width="16" height="16" onclick="getHelp('xlproListHeaderRows.htm')" onmouseover="showReturns('Returns: Int32')"><br>ListNames() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Pastes a list of all nonhidden names onto the worksheet, beginning with the first cell in the range." width="16" height="16" onclick="getHelp('xlmthListNames.htm')" onmouseover="showReturns('Returns: Object')"><br>ListObject<input type="image" src="MSGBOX02.ICO" alt="Returns: ListObject. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ListObject')"><br>LocationInTable<input type="image" src="MSGBOX02.ICO" alt="Returns: XlLocationInTable. This example displays a message box that describes the location of the active cell within the PivotTable report." width="16" height="16" onclick="getHelp('xlproLocationInTable.htm')" onmouseover="showReturns('Returns: XlLocationInTable')"><br>Locked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Locked property as it applies to the ChartObject, ChartObjects, LinkFormat, OLEObject, OLEObjects, Scenario, Shape, and Style objects." width="16" height="16" onclick="getHelp('xlproLocked.htm')" onmouseover="showReturns('Returns: Object')"><br>Merge([Across]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Merges the scenarios from another sheet into the Scenarios collection." width="16" height="16" onclick="getHelp('xlmthMerge.htm')" onmouseover="showReturns('Returns: Void')"><br>MergeArea<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the merged range containing the specified cell. If the specified cell isnt in a merged range, this property returns the specified cell. Read-only Variant." width="16" height="16" onclick="getHelp('xlproMergeArea.htm')" onmouseover="showReturns('Returns: Range')"><br>MergeCells [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the range or style contains merged cells. Read/write Variant." width="16" height="16" onclick="getHelp('xlproMergeCells.htm')" onmouseover="showReturns('Returns: Object')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: Object')"><br>NavigateArrow([TowardPrecedent], [ArrowNumber], [LinkNumber]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Navigates a tracer arrow for the specified range to the precedent, dependent, or error-causing cell or cells. Selects the precedent, dependent, or error cells and returns a Range object that represents the new selection. This method causes an error if it's applied to a cell without visible tracer arrows." width="16" height="16" onclick="getHelp('xlmthNavigateArrow.htm')" onmouseover="showReturns('Returns: Object')"><br>Next<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Worksheet object that represents the next sheet or cell. Read-only." width="16" height="16" onclick="getHelp('xlproNext.htm')" onmouseover="showReturns('Returns: Range')"><br>NoteText([Text], [Start], [Length]) <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the cell note associated with the cell in the upper-left corner of the range. Read/write String." width="16" height="16" onclick="getHelp('xlmthNoteText.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormat property as it applies to the DataLabel, DataLabels, PivotField, Style, and TickLabels objects." width="16" height="16" onclick="getHelp('xlproNumberFormat.htm')" onmouseover="showReturns('Returns: Object')"><br>NumberFormatLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormatLocal property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproNumberFormatLocal.htm')" onmouseover="showReturns('Returns: Object')"><br>Offset<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents a range thats offset from the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproOffset.htm')" onmouseover="showReturns('Returns: Range')"><br>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report." width="16" height="16" onclick="getHelp('xlproOrientation.htm')" onmouseover="showReturns('Returns: Object')"><br>OutlineLevel [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the current outline level of the specified row or column. Read/write Variant." width="16" height="16" onclick="getHelp('xlproOutlineLevel.htm')" onmouseover="showReturns('Returns: Object')"><br>PageBreak [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the location of a page break. Can be one of the following XlPageBreak constants: xlPageBreakAutomatic, xlPageBreakManual, or xlPageBreakNone. Read/write Long." width="16" height="16" onclick="getHelp('xlproPageBreak.htm')" onmouseover="showReturns('Returns: Int32')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Parse([ParseLine], [Destination]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Parses a range of data and breaks it into multiple cells. Distributes the contents of the range to fill several adjacent columns; the range can be no more than one column wide." width="16" height="16" onclick="getHelp('xlmthParse.htm')" onmouseover="showReturns('Returns: Object')"><br>PasteSpecial([Paste], [Operation], [SkipBlanks], [Transpose]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example replaces the data in cells D1:D5 on Sheet1 with the sum of the existing contents and cells C1:C5 on Sheet1." width="16" height="16" onclick="getHelp('xlmthPasteSpecial.htm')" onmouseover="showReturns('Returns: Object')"><br>Phonetic<input type="image" src="MSGBOX02.ICO" alt="Returns: Phonetic. Returns the Phonetic object, which contains information about a specific phonetic text string in a cell." width="16" height="16" onclick="getHelp('xlproPhonetic.htm')" onmouseover="showReturns('Returns: Phonetic')"><br>Phonetics<input type="image" src="MSGBOX02.ICO" alt="Returns: Phonetics. Returns the Phonetics collection of the range. Read only Phonetics." width="16" height="16" onclick="getHelp('xlproPhonetics.htm')" onmouseover="showReturns('Returns: Phonetics')"><br>PivotCell<input type="image" src="MSGBOX02.ICO" alt="Returns: PivotCell. Returns a PivotCell object that represents a cell in a PivotTable report." width="16" height="16" onclick="getHelp('xlproPivotCell.htm')" onmouseover="showReturns('Returns: PivotCell')"><br>PivotField<input type="image" src="MSGBOX02.ICO" alt="Returns: PivotField. Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range." width="16" height="16" onclick="getHelp('xlproPivotField.htm')" onmouseover="showReturns('Returns: PivotField')"><br>PivotItem<input type="image" src="MSGBOX02.ICO" alt="Returns: PivotItem. Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range." width="16" height="16" onclick="getHelp('xlproPivotItem.htm')" onmouseover="showReturns('Returns: PivotItem')"><br>PivotTable<input type="image" src="MSGBOX02.ICO" alt="Returns: PivotTable. Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report." width="16" height="16" onclick="getHelp('xlproPivotTable.htm')" onmouseover="showReturns('Returns: PivotTable')"><br>Precedents<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents all the precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one precedent. Read-only." width="16" height="16" onclick="getHelp('xlproPrecedents.htm')" onmouseover="showReturns('Returns: Range')"><br>PrefixCharacter<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the prefix character for the cell. Read-only Variant." width="16" height="16" onclick="getHelp('xlproPrefixCharacter.htm')" onmouseover="showReturns('Returns: Object')"><br>Previous<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Worksheet object that represents the previous sheet or cell. Read-only." width="16" height="16" onclick="getHelp('xlproPrevious.htm')" onmouseover="showReturns('Returns: Range')"><br>PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Prints the object." width="16" height="16" onclick="getHelp('xlmthPrintOut.htm')" onmouseover="showReturns('Returns: Object')"><br>PrintPreview([EnableChanges]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Shows a preview of the object as it would look when printed." width="16" height="16" onclick="getHelp('xlmthPrintPreview.htm')" onmouseover="showReturns('Returns: Object')"><br>QueryTable<input type="image" src="MSGBOX02.ICO" alt="Returns: QueryTable. Returns a QueryTable object that represents the query table that intersects the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproQueryTable.htm')" onmouseover="showReturns('Returns: QueryTable')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>ReadingOrder [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long." width="16" height="16" onclick="getHelp('xlproReadingOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br>RemoveSubtotal() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Removes subtotals from a list." width="16" height="16" onclick="getHelp('xlmthRemoveSubtotal.htm')" onmouseover="showReturns('Returns: Object')"><br>Replace(What, Replacement, [LookAt], [SearchOrder], [MatchCase], [MatchByte], [SearchFormat], [ReplaceFormat]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. This example replaces every occurrence of the trigonometric function SIN with the function COS. The replacement range is column A on Sheet1." width="16" height="16" onclick="getHelp('xlmthReplace.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Resize<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Resizes the specified range. Returns a Range object that represents the resized range." width="16" height="16" onclick="getHelp('xlproResize.htm')" onmouseover="showReturns('Returns: Range')"><br>Row<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the number of the first row of the first area in the range. Read-only Long." width="16" height="16" onclick="getHelp('xlproRow.htm')" onmouseover="showReturns('Returns: Int32')"><br>RowDifferences(Comparison) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents all the cells whose contents are different from those of the comparison cell in each row." width="16" height="16" onclick="getHelp('xlmthRowDifferences.htm')" onmouseover="showReturns('Returns: Range')"><br>RowHeight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the height of all the rows in the range specified, measured in points. Returns Null if the rows in the specified range arent all the same height. Read/write Variant." width="16" height="16" onclick="getHelp('xlproRowHeight.htm')" onmouseover="showReturns('Returns: Object')"><br>Rows<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. For an Application object, returns a Range object that represents all the rows on the active worksheet. If the active document isnt a worksheet, the Rows property fails. For a Range object, returns a Range object that represents the rows in the specified range. For a Worksheet object, returns a Range object that represents all the rows on the specified worksheet. Read-only Range object." width="16" height="16" onclick="getHelp('xlproRows.htm')" onmouseover="showReturns('Returns: Range')"><br>Run([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Runs the Microsoft Excel macro at this location. The range must be on a macro sheet." width="16" height="16" onclick="getHelp('xlmthRun.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>SetPhonetic() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Creates Phonetic objects for all the cells in the specified range." width="16" height="16" onclick="getHelp('xlmthSetPhonetic.htm')" onmouseover="showReturns('Returns: Void')"><br>Show() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays the built-in dialog box and waits for the user to input data. Boolean." width="16" height="16" onclick="getHelp('xlmthShow.htm')" onmouseover="showReturns('Returns: Object')"><br>ShowDependents([Remove]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Draws tracer arrows to the direct dependents of the range." width="16" height="16" onclick="getHelp('xlmthShowDependents.htm')" onmouseover="showReturns('Returns: Object')"><br>ShowDetail [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. Read/write Variant." width="16" height="16" onclick="getHelp('xlproShowDetail.htm')" onmouseover="showReturns('Returns: Object')"><br>ShowErrors() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Draws tracer arrows through the precedents tree to the cell thats the source of the error, and returns the range that contains that cell." width="16" height="16" onclick="getHelp('xlmthShowErrors.htm')" onmouseover="showReturns('Returns: Object')"><br>ShowPrecedents([Remove]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Draws tracer arrows to the direct precedents of the range." width="16" height="16" onclick="getHelp('xlmthShowPrecedents.htm')" onmouseover="showReturns('Returns: Object')"><br>ShrinkToFit [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example causes text in row one to automatically shrink to fit in the available column width." width="16" height="16" onclick="getHelp('xlproShrinkToFit.htm')" onmouseover="showReturns('Returns: Object')"><br>SmartTags<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTags. Returns a SmartTags object representing the identifier for the specified cell." width="16" height="16" onclick="getHelp('xlproSmartTags.htm')" onmouseover="showReturns('Returns: SmartTags')"><br>Sort([Key1], [Order1], [Key2], [Type], [Order2], [Key3], [Order3], [Header], [OrderCustom], [MatchCase], [Orientation], [SortMethod], [DataOption1], [DataOption2], [DataOption3]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The settings for Header, Order1, Order2, Order3, OrderCustom, and Orientation are saved, for the particular worksheet, each time you use this method. If you dont specify values for these arguments the next time you call the method, the saved values are used.&amp;nbsp; Set these arguments explicitly each time you use Sort method, if you choose not to use the saved values." width="16" height="16" onclick="getHelp('xlmthSort.htm')" onmouseover="showReturns('Returns: Object')"><br>SortSpecial([SortMethod], [Key1], [Order1], [Type], [Key2], [Order2], [Key3], [Order3], [Header], [OrderCustom], [MatchCase], [Orientation], [DataOption1], [DataOption2], [DataOption3]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Note: If no arguments are defined with the Sort method, Microsoft Excel will sort the selection, chosen to be sorted, in ascending order." width="16" height="16" onclick="getHelp('xlmthSortSpecial.htm')" onmouseover="showReturns('Returns: Object')"><br>SoundNote<input type="image" src="MSGBOX02.ICO" alt="Returns: SoundNote. This property should not be used. Sound notes have been removed from Microsoft Excel." width="16" height="16" onclick="getHelp('xlproSoundNote.htm')" onmouseover="showReturns('Returns: SoundNote')"><br>Speak([SpeakDirection], [SpeakFormulas]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Causes the cells of the range to be spoken in row order or column order. " width="16" height="16" onclick="getHelp('xlmthSpeak.htm')" onmouseover="showReturns('Returns: Void')"><br>SpecialCells(Type, [Value]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents all the cells that match the specified type and value. Range object." width="16" height="16" onclick="getHelp('xlmthSpecialCells.htm')" onmouseover="showReturns('Returns: Range')"><br>Style [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. &amp;nbsp;Style property as it applies to the LineFormat object." width="16" height="16" onclick="getHelp('xlproStyle.htm')" onmouseover="showReturns('Returns: Object')"><br>SubscribeTo(Edition, [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthSubscribeTo.htm')" onmouseover="showReturns('Returns: Object')"><br>Subtotal(GroupBy, Function, TotalList, [Replace], [PageBreaks], [SummaryBelowData]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Creates subtotals for the range (or the current region, if the range is a single cell)." width="16" height="16" onclick="getHelp('xlmthSubtotal.htm')" onmouseover="showReturns('Returns: Object')"><br>Summary<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the range is an outlining summary row or column. The range should be a row or a column. Read-only Variant." width="16" height="16" onclick="getHelp('xlproSummary.htm')" onmouseover="showReturns('Returns: Object')"><br>Table([RowInput], [ColumnInput]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Creates a data table based on input values and formulas that you define on a worksheet." width="16" height="16" onclick="getHelp('xlmthTable.htm')" onmouseover="showReturns('Returns: Object')"><br>Text<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects." width="16" height="16" onclick="getHelp('xlproText.htm')" onmouseover="showReturns('Returns: Object')"><br>TextToColumns([Destination], [DataType], [TextQualifier], [ConsecutiveDelimiter], [Tab], [Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [DecimalSeparator], [ThousandsSeparator], [TrailingMinusNumbers]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Parses a column of cells that contain text into several columns." width="16" height="16" onclick="getHelp('xlmthTextToColumns.htm')" onmouseover="showReturns('Returns: Object')"><br>Top<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Object')"><br>Ungroup() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example ungroups any grouped shapes and disassembles any pictures or OLE objects on myDocument." width="16" height="16" onclick="getHelp('xlmthUngroup.htm')" onmouseover="showReturns('Returns: Object')"><br>UnMerge() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Separates a merged area into individual cells." width="16" height="16" onclick="getHelp('xlmthUnMerge.htm')" onmouseover="showReturns('Returns: Void')"><br>UseStandardHeight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the row height of the Range object equals the standard height of the sheet. Returns Null if the range contains more than one row and the rows arent all the same height. Read/write Variant." width="16" height="16" onclick="getHelp('xlproUseStandardHeight.htm')" onmouseover="showReturns('Returns: Object')"><br>UseStandardWidth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the column width of the Range object equals the standard width of the sheet. Returns Null if the range contains more than one column and the columns arent all the same width. Read/write Variant." width="16" height="16" onclick="getHelp('xlproUseStandardWidth.htm')" onmouseover="showReturns('Returns: Object')"><br>Validation<input type="image" src="MSGBOX02.ICO" alt="Returns: Validation. Returns the Validation object that represents data validation for the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproValidation.htm')" onmouseover="showReturns('Returns: Validation')"><br>Value [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: Object')"><br>Value2 [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the cell value. Read/write Variant." width="16" height="16" onclick="getHelp('xlproValue2.htm')" onmouseover="showReturns('Returns: Object')"><br>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproVerticalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br>Width<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Object')"><br>Worksheet<input type="image" src="MSGBOX02.ICO" alt="Returns: Worksheet. Returns a Worksheet object that represents the worksheet containing the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproWorksheet.htm')" onmouseover="showReturns('Returns: Worksheet')"><br>WrapText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. WrapText property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproWrapText.htm')" onmouseover="showReturns('Returns: Object')"><br>XPath<input type="image" src="MSGBOX02.ICO" alt="Returns: XPath. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XPath')"><br><h2>Scenario (1995) <img src="MSGBOX02.ICO" alt="Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) thats named and saved. The Scenario object is a member of the Scenarios collection. The Scenarios collection contains all the defined scenarios for a worksheet." width="16" height="16" onclick="getHelp('xlobjScenario.htm');showMozHelp('Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) thats named and saved. The Scenario object is a member of the Scenarios collection. The Scenarios collection contains all the defined scenarios for a worksheet.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>ChangeScenario(ChangingCells, [Values]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Changes the scenario to have a new set of changing cells and (optionally) scenario values." width="16" height="16" onclick="getHelp('xlmthChangeScenario.htm')" onmouseover="showReturns('Returns: Object')"><br>ChangingCells<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the changing cells for a scenario. Read-only." width="16" height="16" onclick="getHelp('xlproChangingCells.htm')" onmouseover="showReturns('Returns: Range')"><br>Comment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range. Read-only Comment object." width="16" height="16" onclick="getHelp('xlproComment.htm')" onmouseover="showReturns('Returns: String')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Hidden [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Don't confuse this property with the FormulaHidden property." width="16" height="16" onclick="getHelp('xlproHidden.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>Locked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Locked property as it applies to the ChartObject, ChartObjects, LinkFormat, OLEObject, OLEObjects, Scenario, Shape, and Style objects." width="16" height="16" onclick="getHelp('xlproLocked.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Show() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays the built-in dialog box and waits for the user to input data. Boolean." width="16" height="16" onclick="getHelp('xlmthShow.htm')" onmouseover="showReturns('Returns: Object')"><br>Values<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an array that contains the current values of the changing cells for the scenario. Read-only Variant." width="16" height="16" onclick="getHelp('xlproValues.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Scenarios (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) thats named and saved." width="16" height="16" onclick="getHelp('xlobjScenarios.htm');showMozHelp('A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) thats named and saved.');"></h2>Add(Name, ChangingCells, [Values], [Comment], [Locked], [Hidden]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Scenario. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Scenario')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>CreateSummary([ReportType], [ResultCells]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example creates a summary of the scenarios on Sheet1, with result cells in the range C4:C9 on Sheet1." width="16" height="16" onclick="getHelp('xlmthCreateSummary.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Scenario. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Scenario')"><br>Merge(Source) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Merges the scenarios from another sheet into the Scenarios collection." width="16" height="16" onclick="getHelp('xlmthMerge.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>SmartTag (2002) <img src="MSGBOX02.ICO" alt="Represents an identifier that is assigned to a cell." width="16" height="16" onclick="getHelp('xlobjSmartTag.htm');showMozHelp('Represents an identifier that is assigned to a cell.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>DownloadURL<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproDownloadURL.htm')" onmouseover="showReturns('Returns: String')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Properties<input type="image" src="MSGBOX02.ICO" alt="Returns: CustomProperties. Returns a CustomProperties object representing the properties for a smart tag." width="16" height="16" onclick="getHelp('xlproProperties.htm')" onmouseover="showReturns('Returns: CustomProperties')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>SmartTagActions<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTagActions. Returns a SmartTagActions object the type of action for a selected smart tag." width="16" height="16" onclick="getHelp('xlproSmartTagActions.htm')" onmouseover="showReturns('Returns: SmartTagActions')"><br>XML<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a String representing a sample of the XML that would be passed to the action handler. Read-only." width="16" height="16" onclick="getHelp('xlproXML.htm')" onmouseover="showReturns('Returns: String')"><br><h2>SmartTagAction (2002) <img src="MSGBOX02.ICO" alt="Represents the actions that can be performed with smart tags." width="16" height="16" onclick="getHelp('xlobjSmartTagAction.htm');showMozHelp('Represents the actions that can be performed with smart tags.');"></h2>ActiveXControl<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>CheckboxState [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Execute() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Activates a smart tag action that is associated with the smart tag type on a cell." width="16" height="16" onclick="getHelp('xlmthExecute.htm')" onmouseover="showReturns('Returns: Void')"><br>ExpandHelp [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ListSelection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PresentInPane<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>RadioGroupSelection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>TextboxText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSmartTagControlType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: XlSmartTagControlType')"><br><h2>SmartTagActions (2002) <img src="MSGBOX02.ICO" alt="A collection of SmartTagAction objects that represent the actions that can be performed with smart tags." width="16" height="16" onclick="getHelp('xlobjSmartTagActions.htm');showMozHelp('A collection of SmartTagAction objects that represent the actions that can be performed with smart tags.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTagAction. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: SmartTagAction')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>SmartTagOptions (2002) <img src="MSGBOX02.ICO" alt="Represents the options that can be performed with smart tags." width="16" height="16" onclick="getHelp('xlobjSmartTagOptions.htm');showMozHelp('Represents the options that can be performed with smart tags.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>DisplaySmartTags [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSmartTagDisplayMode. Returns or sets an XlSmartTagDisplayMode constant indicating the display features for smart tags. Read/write." width="16" height="16" onclick="getHelp('xlproDisplaySmartTags.htm')" onmouseover="showReturns('Returns: XlSmartTagDisplayMode')"><br>EmbedSmartTags [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to embed smart tags on the specified workbook. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEmbedSmartTags.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>SmartTagRecognizer (2002) <img src="MSGBOX02.ICO" alt="Represents recognition engines which label data with types of information as you work in Microsoft Excel." width="16" height="16" onclick="getHelp('xlobjSmartTagRecognizer.htm');showMozHelp('Represents recognition engines which label data with types of information as you work in Microsoft Excel.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Enabled [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnabled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FullName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name of the object, including its path on disk, as a string. Read-only String." width="16" height="16" onclick="getHelp('xlproFullName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>progID<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br><h2>SmartTagRecognizers (2002) <img src="MSGBOX02.ICO" alt="A collection of SmartTagRecognizer objects that represent recognition engines which label data with types of information as you work in Microsoft Excel." width="16" height="16" onclick="getHelp('xlobjSmartTagRecognizers.htm');showMozHelp('A collection of SmartTagRecognizer objects that represent recognition engines which label data with types of information as you work in Microsoft Excel.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTagRecognizer. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: SmartTagRecognizer')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Recognize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True when data can be labeled as a smart tag. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproRecognize.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>SmartTags (2002) <img src="MSGBOX02.ICO" alt="A collection of SmartTag objects that represent the identifiers assigned to each cell." width="16" height="16" onclick="getHelp('xlobjSmartTags.htm');showMozHelp('A collection of SmartTag objects that represent the identifiers assigned to each cell.');"></h2>Add(SmartTagType) <input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTag. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: SmartTag')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Tab (2002) <img src="MSGBOX02.ICO" alt="Represents a tab in a chart or a worksheet." width="16" height="16" onclick="getHelp('xlobjTab.htm');showMozHelp('Represents a tab in a chart or a worksheet.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Color [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the color of the tick-mark labels on the value axis in Chart1." width="16" height="16" onclick="getHelp('xlproColor.htm')" onmouseover="showReturns('Returns: Object')"><br>ColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. The following examples assume that you're using the default color palette." width="16" height="16" onclick="getHelp('xlproColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>UserAccess (2002) <img src="MSGBOX02.ICO" alt="Represents the user access for a protected range." width="16" height="16" onclick="getHelp('xlobjUserAccess.htm');showMozHelp('Represents the user access for a protected range.');"></h2>AllowEdit [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. In this example, Microsoft Excel notifies the user if cell A1 can be edited or not on a protected worksheet." width="16" height="16" onclick="getHelp('xlproAllowEdit.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br><h2>UserAccessList (2002) <img src="MSGBOX02.ICO" alt="A collection of UserAccess objects that represent the user access for protected ranges." width="16" height="16" onclick="getHelp('xlobjUserAccessList.htm');showMozHelp('A collection of UserAccess objects that represent the user access for protected ranges.');"></h2>Add(Name, AllowEdit) <input type="image" src="MSGBOX02.ICO" alt="Returns: UserAccess. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: UserAccess')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>DeleteAll() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Removes all users associated with access to a&amp;nbsp; protected range on a worksheet." width="16" height="16" onclick="getHelp('xlmthDeleteAll.htm')" onmouseover="showReturns('Returns: Void')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: UserAccess. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: UserAccess')"><br><h2>Validation (1997) <img src="MSGBOX02.ICO" alt="Represents data validation for a worksheet range." width="16" height="16" onclick="getHelp('xlobjValidation.htm');showMozHelp('Represents data validation for a worksheet range.');"></h2>Add(Type, [AlertStyle], [Operator], [Formula1], [Formula2]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Void')"><br>AlertStyle<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Use the Add method to set the alert style for a range. If the range already has data validation, use the Modify method to change the alert style." width="16" height="16" onclick="getHelp('xlproAlertStyle.htm')" onmouseover="showReturns('Returns: Int32')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>ErrorMessage [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the data validation error message. Read/write String." width="16" height="16" onclick="getHelp('xlproErrorMessage.htm')" onmouseover="showReturns('Returns: String')"><br>ErrorTitle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the title of the data-validation error dialog box. Read/write String." width="16" height="16" onclick="getHelp('xlproErrorTitle.htm')" onmouseover="showReturns('Returns: String')"><br>Formula1<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. Read-only String." width="16" height="16" onclick="getHelp('xlproFormula1.htm')" onmouseover="showReturns('Returns: String')"><br>Formula2<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the value or expression associated with the second part of a conditional format or data validation. Used only when the data validation conditional format Operator property is xlBetween or xlNotBetween. Can be a constant value, a string value, a cell reference, or a formula. Read-only String." width="16" height="16" onclick="getHelp('xlproFormula2.htm')" onmouseover="showReturns('Returns: String')"><br>IgnoreBlank [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if blank values are permitted by the range data validation. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIgnoreBlank.htm')" onmouseover="showReturns('Returns: Boolean')"><br>IMEMode [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Note that this property can be set only when Japanese language support has been installed and selected." width="16" height="16" onclick="getHelp('xlproIMEMode.htm')" onmouseover="showReturns('Returns: Int32')"><br>InCellDropdown [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproInCellDropdown.htm')" onmouseover="showReturns('Returns: Boolean')"><br>InputMessage [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the data validation input message. Read/write String." width="16" height="16" onclick="getHelp('xlproInputMessage.htm')" onmouseover="showReturns('Returns: String')"><br>InputTitle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the title of the data-validation input dialog box. Read/write String." width="16" height="16" onclick="getHelp('xlproInputTitle.htm')" onmouseover="showReturns('Returns: String')"><br>Modify([Type], [AlertStyle], [Operator], [Formula1], [Formula2]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Modifies the data validation or conditional format. For more information, click the object you want to modify." width="16" height="16" onclick="getHelp('xlmthModify.htm')" onmouseover="showReturns('Returns: Void')"><br>Operator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example changes the formula for conditional format one, for cells E1:E10 if the formula specifies &amp;quot;less than 5.&amp;quot;" width="16" height="16" onclick="getHelp('xlproOperator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>ShowError [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the data validation error message will be displayed whenever the user enters invalid data. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowError.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowInput [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the data validation input message will be displayed whenever the user selects a cell in the data validation range. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowInput.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: Int32')"><br>Value<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Worksheet (1995) <img src="MSGBOX02.ICO" alt="Represents a worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook." width="16" height="16" onclick="getHelp('xlobjWorksheet.htm');showMozHelp('Represents a worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook.');"></h2>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.htm')" onmouseover="showReturns('Returns: Void')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Arcs([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoFilter<input type="image" src="MSGBOX02.ICO" alt="Returns: AutoFilter. Returns an AutoFilter object if filtering is on. Returns Nothing if filtering is off. Read-only." width="16" height="16" onclick="getHelp('xlproAutoFilter.htm')" onmouseover="showReturns('Returns: AutoFilter')"><br>AutoFilterMode [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the AutoFilter drop-down arrows are currently displayed on the sheet. This property is independent of the FilterMode property. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoFilterMode.htm')" onmouseover="showReturns('Returns: Boolean')"><br>BeforeDoubleClick<input type="image" src="MSGBOX02.ICO" alt="Returns: . The DoubleClick method doesn't cause this event to occur." width="16" height="16" onclick="getHelp('xlevtBeforeDoubleClick.htm')" onmouseover="showReturns('Returns: ')"><br>BeforeRightClick<input type="image" src="MSGBOX02.ICO" alt="Returns: . Like other worksheet events, this event doesn't occur if you right-click while the pointer is on a shape or a command bar (a toolbar or menu bar)." width="16" height="16" onclick="getHelp('xlevtBeforeRightClick.htm')" onmouseover="showReturns('Returns: ')"><br>Buttons([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Calculate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table." width="16" height="16" onclick="getHelp('xlmthCalculate.htm')" onmouseover="showReturns('Returns: Void')"><br>Cells<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Because the default property for the Range object, you can specify the row and column index immediately after the Cells keyword. For more information, see the Item property and the examples for this topic." width="16" height="16" onclick="getHelp('xlproCells.htm')" onmouseover="showReturns('Returns: Range')"><br>Change<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when cells on the worksheet are changed by the user or by an external link." width="16" height="16" onclick="getHelp('xlevtChange.htm')" onmouseover="showReturns('Returns: ')"><br>ChartObjects([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents either a single embedded chart (a ChartObject object) or a collection of all the embedded charts (a ChartObjects object) on the sheet." width="16" height="16" onclick="getHelp('xlmthChartObjects.htm')" onmouseover="showReturns('Returns: Object')"><br>CheckBoxes([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.htm')" onmouseover="showReturns('Returns: Void')"><br>CircleInvalid() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Circles invalid entries on the worksheet." width="16" height="16" onclick="getHelp('xlmthCircleInvalid.htm')" onmouseover="showReturns('Returns: Void')"><br>CircularReference<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. 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." width="16" height="16" onclick="getHelp('xlproCircularReference.htm')" onmouseover="showReturns('Returns: Range')"><br>ClearArrows() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Clears the tracer arrows from the worksheet. Tracer arrows are added by using the auditing feature." width="16" height="16" onclick="getHelp('xlmthClearArrows.htm')" onmouseover="showReturns('Returns: Void')"><br>ClearCircles() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Clears circles from invalid entries on the worksheet." width="16" height="16" onclick="getHelp('xlmthClearCircles.htm')" onmouseover="showReturns('Returns: Void')"><br>CodeName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the code name for the object. Read-only String." width="16" height="16" onclick="getHelp('xlproCodeName.htm')" onmouseover="showReturns('Returns: String')"><br>Columns<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. " width="16" height="16" onclick="getHelp('xlproColumns.htm')" onmouseover="showReturns('Returns: Range')"><br>Comments<input type="image" src="MSGBOX02.ICO" alt="Returns: Comments. Returns a Comments collection that represents all the comments for the specified worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproComments.htm')" onmouseover="showReturns('Returns: Comments')"><br>ConsolidationFunction<input type="image" src="MSGBOX02.ICO" alt="Returns: XlConsolidationFunction. This example displays a message box if the current consolidation is using the SUM function." width="16" height="16" onclick="getHelp('xlproConsolidationFunction.htm')" onmouseover="showReturns('Returns: XlConsolidationFunction')"><br>ConsolidationOptions<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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 Variant." width="16" height="16" onclick="getHelp('xlproConsolidationOptions.htm')" onmouseover="showReturns('Returns: Object')"><br>ConsolidationSources<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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 Variant." width="16" height="16" onclick="getHelp('xlproConsolidationSources.htm')" onmouseover="showReturns('Returns: Object')"><br>Copy([Before], [After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Copies the range to the specified range or to the Clipboard." width="16" height="16" onclick="getHelp('xlmthCopy.htm')" onmouseover="showReturns('Returns: Void')"><br>CreateObjRef(requestedType) <input type="image" src="MSGBOX02.ICO" alt="Returns: ObjRef. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ObjRef')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>CustomProperties<input type="image" src="MSGBOX02.ICO" alt="Returns: CustomProperties. Returns a CustomProperties object representing the identifier information associated with a worksheet." width="16" height="16" onclick="getHelp('xlproCustomProperties.htm')" onmouseover="showReturns('Returns: CustomProperties')"><br>Deactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the chart, worksheet, or workbook is deactivated." width="16" height="16" onclick="getHelp('xlevtDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>DisplayAutomaticPageBreaks [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayPageBreaks [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if page breaks (both automatic and manual) on the specified worksheet are displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayPageBreaks.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayRightToLeft [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the specified window or worksheet is displayed from right to left instead of from left to right. False if the object is displayed from left to right. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayRightToLeft.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DocEvents_Event_Activate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>DocEvents_Event_Calculate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>DrawingObjects([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Drawings([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>DropDowns([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>EnableAutoFilter [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if AutoFilter arrows are enabled when user-interface-only protection is turned on. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableAutoFilter.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableCalculation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel automatically recalculates the worksheet when necessary. False if Excel doesn't recalculate the sheet. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableCalculation.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableOutlining [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if outlining symbols are enabled when user-interface-only protection is turned on. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableOutlining.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnablePivotTable [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if PivotTable controls and actions are enabled when user-interface-only protection is turned on. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnablePivotTable.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableSelection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlEnableSelection. This property takes effect only when the worksheet is protected: xlNoSelection prevents any selection on the sheet, xlUnlockedCells allows only those cells whose Locked property is False to be selected, and xlNoRestrictions allows any cell to be selected." width="16" height="16" onclick="getHelp('xlproEnableSelection.htm')" onmouseover="showReturns('Returns: XlEnableSelection')"><br>Equals(obj) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Evaluate(Name) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Converts a Microsoft Excel name to an object or a value." width="16" height="16" onclick="getHelp('xlmthEvaluate.htm')" onmouseover="showReturns('Returns: Object')"><br>FilterMode<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the worksheet is in filter mode. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproFilterMode.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FollowHyperlink<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when you click any hyperlink on a worksheet. For application- and workbook-level events, see the SheetFollowHyperlink event." width="16" height="16" onclick="getHelp('xlevtFollowHyperlink.htm')" onmouseover="showReturns('Returns: ')"><br>GetHashCode() <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>GetLifetimeService() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>GetType() <input type="image" src="MSGBOX02.ICO" alt="Returns: Type. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Type')"><br>GroupBoxes([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>GroupObjects([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>HPageBreaks<input type="image" src="MSGBOX02.ICO" alt="Returns: HPageBreaks. Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only." width="16" height="16" onclick="getHelp('xlproHPageBreaks.htm')" onmouseover="showReturns('Returns: HPageBreaks')"><br>Hyperlinks<input type="image" src="MSGBOX02.ICO" alt="Returns: Hyperlinks. Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet." width="16" height="16" onclick="getHelp('xlproHyperlinks.htm')" onmouseover="showReturns('Returns: Hyperlinks')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>InitializeLifetimeService() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Labels([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Lines([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>ListBoxes([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>ListObjects<input type="image" src="MSGBOX02.ICO" alt="Returns: ListObjects. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ListObjects')"><br>MailEnvelope<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoEnvelope. Rrepresents an e-mail header for a document." width="16" height="16" onclick="getHelp('xlproMailEnvelope.htm')" onmouseover="showReturns('Returns: MsoEnvelope')"><br>Move([Before], [After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the sheet to another location in the workbook." width="16" height="16" onclick="getHelp('xlmthMove.htm')" onmouseover="showReturns('Returns: Void')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Names<input type="image" src="MSGBOX02.ICO" alt="Returns: Names. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproNames.htm')" onmouseover="showReturns('Returns: Names')"><br>Next<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns a Worksheet object that represents the next sheet or cell. Read-only." width="16" height="16" onclick="getHelp('xlproNext.htm')" onmouseover="showReturns('Returns: Object')"><br>OLEObjects([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents either a single OLE object (an OLEObjects collection) on the chart or sheet. Read-only." width="16" height="16" onclick="getHelp('xlmthOLEObjects.htm')" onmouseover="showReturns('Returns: Object')"><br>OnCalculate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnData [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnDoubleClick [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnEntry [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnSheetActivate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnSheetDeactivate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OptionButtons([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Outline<input type="image" src="MSGBOX02.ICO" alt="Returns: Outline. Returns an Outline object that represents the outline for the specified worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproOutline.htm')" onmouseover="showReturns('Returns: Outline')"><br>Ovals([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>PageSetup<input type="image" src="MSGBOX02.ICO" alt="Returns: PageSetup. Returns a PageSetup object that contains all the page setup settings for the specified object. Read-only." width="16" height="16" onclick="getHelp('xlproPageSetup.htm')" onmouseover="showReturns('Returns: PageSetup')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Paste([Destination], [Link]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Pastes chart data from the Clipboard into the specified chart." width="16" height="16" onclick="getHelp('xlmthPaste.htm')" onmouseover="showReturns('Returns: Void')"><br>PasteSpecial([Format], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [NoHTMLFormatting]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example replaces the data in cells D1:D5 on Sheet1 with the sum of the existing contents and cells C1:C5 on Sheet1." width="16" height="16" onclick="getHelp('xlmthPasteSpecial.htm')" onmouseover="showReturns('Returns: Void')"><br>Pictures([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>PivotTables([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. Read-only." width="16" height="16" onclick="getHelp('xlmthPivotTables.htm')" onmouseover="showReturns('Returns: Object')"><br>PivotTableUpdate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after a PivotTable report is updated on a worksheet." width="16" height="16" onclick="getHelp('xlevtPivotTableUpdate.htm')" onmouseover="showReturns('Returns: ')"><br>PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection]) <input type="image" src="MSGBOX02.ICO" alt="Returns: PivotTable. Creates a PivotTable object. This method doesnt display the PivotTable Wizard. This method isnt available for OLE DB data sources. Use the Add method to add a PivotTable cache, and then create a PivotTable report based on the cache. PivotTable object." width="16" height="16" onclick="getHelp('xlmthPivotTableWizard.htm')" onmouseover="showReturns('Returns: PivotTable')"><br>Previous<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns a Worksheet object that represents the previous sheet or cell. Read-only." width="16" height="16" onclick="getHelp('xlproPrevious.htm')" onmouseover="showReturns('Returns: Object')"><br>PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Prints the object." width="16" height="16" onclick="getHelp('xlmthPrintOut.htm')" onmouseover="showReturns('Returns: Void')"><br>PrintPreview([EnableChanges]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Shows a preview of the object as it would look when printed." width="16" height="16" onclick="getHelp('xlmthPrintPreview.htm')" onmouseover="showReturns('Returns: Void')"><br>Protect([Password], [DrawingObjects], [Contents], [Scenarios], [UserInterfaceOnly], [AllowFormattingCells], [AllowFormattingColumns], [AllowFormattingRows], [AllowInsertingColumns], [AllowInsertingRows], [AllowInsertingHyperlinks], [AllowDeletingColumns], [AllowDeletingRows], [AllowSorting], [AllowFiltering], [AllowUsingPivotTables]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. If you apply the Protect method with the UserInterfaceOnly argument set to True to a worksheet and then save the workbook, the entire worksheet (not just the interface) will be fully protected when you reopen the workbook. To re-enable the user interface protection after the workbook is opened, you must again apply the Protect method with UserInterfaceOnly set to True." width="16" height="16" onclick="getHelp('xlmthProtect.htm')" onmouseover="showReturns('Returns: Void')"><br>ProtectContents<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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." width="16" height="16" onclick="getHelp('xlproProtectContents.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ProtectDrawingObjects<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if shapes are protected. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproProtectDrawingObjects.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Protection<input type="image" src="MSGBOX02.ICO" alt="Returns: Protection. Returns a Protection object that represents the protection options of the worksheet." width="16" height="16" onclick="getHelp('xlproProtection.htm')" onmouseover="showReturns('Returns: Protection')"><br>ProtectionMode<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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." width="16" height="16" onclick="getHelp('xlproProtectionMode.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ProtectScenarios<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the worksheet scenarios are protected. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproProtectScenarios.htm')" onmouseover="showReturns('Returns: Boolean')"><br>QueryTables<input type="image" src="MSGBOX02.ICO" alt="Returns: QueryTables. Returns the QueryTables collection that represents all the query tables on the specified worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproQueryTables.htm')" onmouseover="showReturns('Returns: QueryTables')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>Rectangles([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>ResetAllPageBreaks() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Resets all page breaks on the specified worksheet." width="16" height="16" onclick="getHelp('xlmthResetAllPageBreaks.htm')" onmouseover="showReturns('Returns: Void')"><br>Rows<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. For an Application object, returns a Range object that represents all the rows on the active worksheet. If the active document isnt a worksheet, the Rows property fails. For a Range object, returns a Range object that represents the rows in the specified range. For a Worksheet object, returns a Range object that represents all the rows on the specified worksheet. Read-only Range object." width="16" height="16" onclick="getHelp('xlproRows.htm')" onmouseover="showReturns('Returns: Range')"><br>SaveAs(Filename, [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AddToMru], [TextCodepage], [TextVisualLayout], [Local]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves changes to the chart or worksheet in a different file." width="16" height="16" onclick="getHelp('xlmthSaveAs.htm')" onmouseover="showReturns('Returns: Void')"><br>Scenarios([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents either a single scenario (a Scenario object) or a collection of scenarios (a Scenarios object) on the worksheet." width="16" height="16" onclick="getHelp('xlmthScenarios.htm')" onmouseover="showReturns('Returns: Object')"><br>Scripts<input type="image" src="MSGBOX02.ICO" alt="Returns: Scripts. Returns the Scripts collection, which contains Script objects representing blocks of script or code in the specified document when its saved as a Web page." width="16" height="16" onclick="getHelp('xlproScripts.htm')" onmouseover="showReturns('Returns: Scripts')"><br>ScrollArea [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. 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." width="16" height="16" onclick="getHelp('xlproScrollArea.htm')" onmouseover="showReturns('Returns: String')"><br>ScrollBars([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Select([Replace]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Void')"><br>SelectionChange<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the selection changes on a worksheet." width="16" height="16" onclick="getHelp('xlevtSelectionChange.htm')" onmouseover="showReturns('Returns: ')"><br>SetBackgroundPicture(Filename) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the background graphic for a worksheet or chart." width="16" height="16" onclick="getHelp('xlmthSetBackgroundPicture.htm')" onmouseover="showReturns('Returns: Void')"><br>Shapes<input type="image" src="MSGBOX02.ICO" alt="Returns: Shapes. Returns a Shapes object that represents all the shapes on the worksheet or chart sheet. Read-only." width="16" height="16" onclick="getHelp('xlproShapes.htm')" onmouseover="showReturns('Returns: Shapes')"><br>ShowAllData() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to All." width="16" height="16" onclick="getHelp('xlmthShowAllData.htm')" onmouseover="showReturns('Returns: Void')"><br>ShowDataForm() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Displays the data form associated with the worksheet." width="16" height="16" onclick="getHelp('xlmthShowDataForm.htm')" onmouseover="showReturns('Returns: Void')"><br>SmartTags<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTags. Returns a SmartTags object representing the identifier for the specified cell." width="16" height="16" onclick="getHelp('xlproSmartTags.htm')" onmouseover="showReturns('Returns: SmartTags')"><br>Spinners([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>StandardHeight<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the standard (default) height of all the rows in the worksheet, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproStandardHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>StandardWidth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the standard (default) width of all the columns in the worksheet. Read/write Double." width="16" height="16" onclick="getHelp('xlproStandardWidth.htm')" onmouseover="showReturns('Returns: Double')"><br>Tab<input type="image" src="MSGBOX02.ICO" alt="Returns: Tab. Returns a Tab object for a chart or a worksheet." width="16" height="16" onclick="getHelp('xlproTab.htm')" onmouseover="showReturns('Returns: Tab')"><br>TextBoxes([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>ToString() <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>TransitionExpEval [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproTransitionExpEval.htm')" onmouseover="showReturns('Returns: Boolean')"><br>TransitionFormEntry [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel uses Lotus 1-2-3 formula entry rules for the worksheet. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproTransitionFormEntry.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSheetType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: XlSheetType')"><br>Unprotect([Password]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected." width="16" height="16" onclick="getHelp('xlmthUnprotect.htm')" onmouseover="showReturns('Returns: Void')"><br>UsedRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the used range on the specified worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproUsedRange.htm')" onmouseover="showReturns('Returns: Range')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSheetVisibility. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: XlSheetVisibility')"><br>VPageBreaks<input type="image" src="MSGBOX02.ICO" alt="Returns: VPageBreaks. Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only." width="16" height="16" onclick="getHelp('xlproVPageBreaks.htm')" onmouseover="showReturns('Returns: VPageBreaks')"><br>XmlDataQuery(XPath, [SelectionNamespaces], [Map]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Range')"><br>XmlMapQuery(XPath, [SelectionNamespaces], [Map]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Range')"><br><h2>Worksheets (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet." width="16" height="16" onclick="getHelp('xlobjWorksheets.htm');showMozHelp('A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.');"></h2>Add([Before], [After], [Count], [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Object')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Copy([Before], [After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Copies the range to the specified range or to the Clipboard." width="16" height="16" onclick="getHelp('xlmthCopy.htm')" onmouseover="showReturns('Returns: Void')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>FillAcrossSheets(Range, [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example fills the range A1:C5 on Sheet1, Sheet5, and Sheet7 with the contents of the same range on Sheet1." width="16" height="16" onclick="getHelp('xlmthFillAcrossSheets.htm')" onmouseover="showReturns('Returns: Void')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>HPageBreaks<input type="image" src="MSGBOX02.ICO" alt="Returns: HPageBreaks. Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only." width="16" height="16" onclick="getHelp('xlproHPageBreaks.htm')" onmouseover="showReturns('Returns: HPageBreaks')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Object')"><br>Move([Before], [After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the sheet to another location in the workbook." width="16" height="16" onclick="getHelp('xlmthMove.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Prints the object." width="16" height="16" onclick="getHelp('xlmthPrintOut.htm')" onmouseover="showReturns('Returns: Void')"><br>PrintPreview([EnableChanges]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Shows a preview of the object as it would look when printed." width="16" height="16" onclick="getHelp('xlmthPrintPreview.htm')" onmouseover="showReturns('Returns: Void')"><br>Select([Replace]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Void')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: Object')"><br>VPageBreaks<input type="image" src="MSGBOX02.ICO" alt="Returns: VPageBreaks. Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only." width="16" height="16" onclick="getHelp('xlproVPageBreaks.htm')" onmouseover="showReturns('Returns: VPageBreaks')"><br></body> </html>