Skip to content

Get Range Size

Returns the bounding dimensions (rows and columns) of the specified range, trimming only trailing empty rows and columns.

Properties

NameDescriptionRequired
Column CountThe number of columns in use included in the specified range.
RangeSpecifies the range of cells to be read. If this value is not specified, all used cells of the spreadsheet is read. If the value consists of only one cell, all used rows in the spreadsheet are read starting from that cell. (Default: A1)
Row CountThe number of rows in use included in the specified range.
Sheet NameThe name of the worksheet containing the target range.☑️