Get the Row Count in a Worksheet Range

Get the number of rows in an Excel sheet.

This procedure is part of the Excel Book (BDK). To use this book, you must first learn it in your agent.

Input Concepts

Concept	Description	Type	Required
worksheet range	The reference to the Excel range.	excel range reference	Yes

Output Concepts

Concept	Description	Type
row count	The number of rows in the sheet range.	number

Examples

Get the number of rows in an Excel sheet.

get the sheet's used range
use the above as the range
get row count in the range