Home ยป Range.EntireRow property
Learn
Excel Macro: Delete Blank or Empty Rows
Blank rows can often cause problems with formulas. This macro can help automate delete blank or empty rows. Get this VBA code now!
Learn
Excel Macro: Highlight the Active Row and Column
The VBA code examples show ways to highlight the active cell or the rows and columns that contain the active cell. Get the VBA code now!
Range.Column property Range.CurrentRegion property Range.Select method Range.EntireColumn property Range.EntireRow property IsEmpty function Worksheet.SelectionChange event Worksheet.BeforeDoubleClick event Application.ScreenUpdating property Interior.ColorIndex property Range.Interior property Range.Address property On Error statement
Docs
Range.EntireRow property
Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only. Syntax expression.EntireRow expression A variable […]