Click or drag to resize
Range Methods

The Range type exposes the following members.

Methods
  NameDescription
Public methodStatic memberCell
Creates a range referencing one cell.
Public methodStatic memberCells
Creates a range referencing an arbitrary range of cells.
Public methodClone
Creates a copy of this Range.
Public methodStatic memberCol
Creates a range consisting of one column.
Public methodStatic memberCols
Creates a range of the specified columns.
Public methodEquals
Determines whether this range is equal to another range.
(Overrides ObjectEquals(Object).)
Public methodExpandRange
Sets the range based on the top, left corner of the range, and the number of rows and columns in the range.
Public methodStatic memberFromLTRB
Creates a range from the left, top, right, and bottom row and column indexes.
Public methodGetFirstCell
Gets the first cell.
Public methodGetHashCode
Calculates a hash code for this Range.
(Overrides ObjectGetHashCode.)
Public methodGetNextCell(UInt32, UInt32)
Gets the next cell, in row order.
Public methodGetNextCell(UInt32, UInt32, Boolean)
Gets the next cell, in either row or column order.
Public methodInsertCols
Inserts columns at a specified starting location.
Public methodInsertRows
Inserts rows at a specified location.
Public methodIntersectRange(Range)
Tests if this range intersects with a specified range.
Public methodStatic memberIntersectRange(Range, Range)
Tests if tho ranges intersect.
Public methodStatic memberInvalidRange
Creates an invalid range.
Public methodIsCellInRange
Determines whether a specified cell is within this range.
Public methodStatic memberRow
Creates a range consisting of one row.
Public methodStatic memberRows
Creates a range of the specified rows.
Public methodStatic memberTable
Creates a range that references an entire table.
Public methodUnionRange(Range)
Calculates the union of this range with another range.
Public methodStatic memberUnionRange(Range, Range)
Calculates the union of two ranges.
Top
See Also