CreateRange

CreateRange(string, string)

Creates a Range object from a range of cells.

public Range CreateRange(string upperLeftCell, string lowerRightCell)
Parameter Type Description
upperLeftCell String Upper left cell name.
lowerRightCell String Lower 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)
Parameter Type Description
firstRow Int32 First row of this range
firstColumn Int32 First column of this range
totalRows Int32 Number of rows
totalColumns Int32 Number 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)
Parameter Type Description
address String The 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)
Parameter Type Description
firstIndex Int32 First row index or first column index, zero based.
number Int32 Total number of rows or columns, one based.
isVertical Boolean True - Range created from columns of cells. False - Range created from rows of cells.

Return Value

A Range object.

See Also