The EntireRow property returns a new range containing every cell in each row of the current range. Returns a WksRange object. This is a read-only property.
Syntax
object.EntireRow
Remarks
This is the equivalent of clicking on a row number button in the worksheet.
Example 1
This example demonstrates how to return the last column.
Debug.Print WksRange. EntireRow.LastColumn
Example 2
This example demonstrates how to set the row height.
WksRange. EntireRow .RowHeight = 20
Used by: WksRange object