The RowCount property returns the number of rows in the range. Returns a long. This is a read-only property.
Syntax
object.RowCount
Example
This example demonstrates how to return the number of rows in a range.
Debug.Print WksRange. RowCount
Used by: WksRange object