ExcelBanter - How van I return the range row quantity

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How van I return the range row quantity (https://www.excelbanter.com/excel-discussion-misc-queries/71483-how-van-i-return-range-row-quantity.html)

Tom Weston

How van I return the range row quantity

Help
Does anybody know how to return the number of rows in range?

Tom

Bob Phillips

How van I return the range row quantity

=ROWS(rng)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom Weston" wrote in message
...
Help
Does anybody know how to return the number of rows in range?

Tom

All times are GMT +1. The time now is 08:40 PM.