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