Cells.CreateRange

CreateRange(string, string)

Creates a Range object from a range of cells.

public Range CreateRange(string upperLeftCell, string lowerRightCell)
ParameterTypeDescription
upperLeftCellStringUpper left cell name.
lowerRightCellStringLower right cell name.

Return Value

A Range object

See Also


CreateRange(int, int, int, int)

Creates a Range object from a range of cells.

public Range CreateRange(int firstRow, int firstColumn, int totalRows, int totalColumns)
ParameterTypeDescription
firstRowInt32First row of this range
firstColumnInt32First column of this range
totalRowsInt32Number of rows
totalColumnsInt32Number of columns

Return Value

A Range object

See Also


CreateRange(string)

Creates a Range object from an address of the range.

public Range CreateRange(string address)
ParameterTypeDescription
addressStringThe address of the range.

Return Value

A Range object

See Also


CreateRange(int, int, bool)

Creates a Range object from rows of cells or columns of cells.

public Range CreateRange(int firstIndex, int number, bool isVertical)
ParameterTypeDescription
firstIndexInt32First row index or first column index, zero based.
numberInt32Total number of rows or columns, one based.
isVerticalBooleanTrue - Range created from columns of cells. False - Range created from rows of cells.

Return Value

A Range object.

See Also