findRangeFromCoordinate method



Returns a reference to the range object with the specified coordinates.

Syntax

Range = Sheet.findRangeFromCoordinate(startCol, startRow, endCol, endRow)

Applies to

Sheet object.

Parameters

startCol
integer. The numeric index of the starting column for the range. Indexing is 0-based, for example, 0 is column A, 1 is column B, and so on.
startRow
integer. The numeric index of the starting row for the range. Indexing is 0-based, for example, 0 is row 1, 1 is row 2, and so on.
endCol
integer. The numeric index of the ending column for the range.
endRow
integer. The numeric index of the ending row for the range.

Return value

Range. A reference to the Range object with the specified coordinates.

See also
findEntireSheetRange method
findRangeFromString method
Selection property