Range.EntireRow (Excel)
Returns a Range object that represents the entire row (or rows) that contains the specified range.
Dim rngEntireRow As Range
Set rngEntireRow = ActiveCell.EntireRow
Returns a Range object that represents the entire row (or rows) that contains the specified range.
Dim rngEntireRow As Range
Set rngEntireRow = ActiveCell.EntireRow