XlsName Properties

Gets / sets boolean value that is contained by this range.

Returns aBorders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).

Gets/sets built in style.

Returns a Range object that represents the cells in the specified range. Read-only.

Returns a Range object that represents the cells in the specified range. Read-only.

Returns name of the Style object that represents the style of the specified range. Read/write String.

Returns the number of the first column in the first area in the specified range. Read-only.

Column group level. Read-only. -1 - Not all columns in the range have same group level. 0 - No grouping, 1 - 7 - Group level.

For a Range object, returns an array of Range objects that represent the columns in the specified range.

Returns or sets the width of all columns in the specified range. Read/write Double.

Comment assigned to the range. Read-only.

Gets the comment value of the nameManager.

Collection of conditional formats.

Returns the number of objects in the collection. Read-only.

Data validation for the range.

Gets / sets DateTime contained by this cell. Read-write DateTime.

Returns a Range object that represents the cell at the end of the region that contains the source range.

Returns a Range object that represents the entire column (or columns) that contains the specified range. Read-only.

Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only.

Returns the calculated value of a formula.

Gets / sets error value that is contained by this range.

Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write Variant.

Represents array-entered formula. Visit http://www.cpearson.com/excel/array.htm for more information.

Returns or sets the formula array for the range, using R1C1-style notation.

Returns the calculated value of the formula as a boolean.

Get / set formula DateTime value contained by this cell. DateTime.MinValue if not all cells of the range have same DateTime value.

Returns the calculated value of the formula as a string.

Gets / sets number value evaluated by formula.

Returns or sets the formula for the range, using R1C1-style notation.

Gets / sets string value evaluated by formula.

Indicates whether range contains boolean value. Read-only.

Indicates whether specified range object has data validation. If Range is not single cell, then returns true only if all cells have data validation. Read-only.

Indicates whether range contains DateTime value. Read-only.

Indicates whether range contains error value.

Indicates is current range has external formula. Read-only.

True if all cells in the range contain formulas; False if at least one of the cells in the range doesn't contain a formula. Read-only Boolean.

Indicates whether range contains array-entered formula. Read-only.

Indicates if current range has formula bool value. Read only.

Indicates if current range has formula value formatted as DateTime. Read-only.

Indicates if current range has formula error value. Read only.

Gets a value indicating whether the referenced range contains a formula that evaluates to a number.

Gets a value indicating whether the referenced range contains a formula that results in a string value.

Indicates whether this range is part of merged range. Read-only.

Indicates whether the range contains number. Read-only.

Indicates whether cell contains formatted rich text string.

Indicates whether the range contains String. Read-only.

Indicates whether range has default style. False means default style. Read-only.

Returns or sets the horizontal alignment for the specified object. Read/write HorizontalAlignType.

Gets and sets the html string which contains data and some formattings in this cell.

Gets the collection of hyperlinks associated with the range referred to by this instance.

Represents ignore error options. If not single cell returs concatenateed flags.

Returns or sets the indent level for the cell or range. Can be an integer from 0 to 15. Read/write Integer.

Index of the Name object in the workbook's Names collection.

Indicates whether the range is blank. Read-only.

Indicates whether name is buildin or not.

Indicates whether the name is extern name.

True if the formula will be hidden when the worksheet is protected. False if at least part of formula in the range is not hidden.

Indicates whether this is function.

Indicates whether this range is grouped by column. Read-only.

Indicates whether this range is grouped by row. Read-only.

Indicates whether cell is initialized. Read-only.

Indicates whether current name is locally defined name. Read-only.

Indicates whether all values in the range are preserved as strings.

True if Microsoft Excel wraps the text in the object. Read/write Boolean.

Get cell range. Read-only.

Gets / sets cell by row and column index. Row and column indexes are one-based.

Gets cell range. Read-only.

Get cell range. Row and column indexes are one-based. Read-only.

Returns last column of the range. Read-only.

Returns last row of the range. Read-only.

Returns a Range object that represents the merged range containing the specified cell. If the specified cell is not part of a merged range, this property returns NULL. Read-only.

Name of the Name object.

Same as Name.

Format of current cell. Analog of Style.NumberFormat property.

Returns cell value after number format application. Read-only.

Gets / sets double value of the range.

Reference to Parent object. Read-only.

Returns the range reference in the language of the macro. Read-only String.

Returns the range reference for the specified range in the language of the user. Read-only String.

Returns range Address in format "'Sheet1'!$A$1".

Gets the global address for the range in the worksheet, formatted for Excel 2007 and later.

Returns the range reference using R1C1 notation. Read-only String.

Returns the range reference using R1C1 notation. Read-only String.

Get quantity of instance references.

Gets / sets Range associated with the Name object.

String with rich text formatting. Read-only.

Returns the number of the first row of the first area in the range. Read-only Long.

Row group level. Read-only. -1 - Not all rows in the range have same group level. 0 - No grouping, 1 - 7 - Group level.

Returns the height of all the rows in the range specified, measured in points. Returns Double.MinValue if the rows in the specified range aren't all the same height. Read / write Double.

For a Range object, returns an array of Range objects that represent the rows in the specified range.

Returns string representation of the name's scope. Read-only.

Returns a Style object that represents the style of the specified range. Read/write IStyle.

Gets / sets string value of the range.

Gets / sets time value of the range.

For the Name object, a string containing the formula that the name is defined to refer to.

Returns or sets the cell value. Read/write Variant. The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types.

Gets named range formula in R1C1 style. Read only.

Returns or sets the vertical alignment of the specified object. Read/write VerticalAlignType.

Determines whether the object is visible. Read/write Boolean.

Get worksheet of Name Object.