EntireRow Property

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

object.EntireRow =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