Worksheet.Rows (Excel)

Returns a Range object that represents all the rows on the specified worksheet.

Using the Rows property without an object qualifier is equivalent to using ActiveSheet.Rows. If the active document isn't a worksheet, the Rows property fails. To return a single row, use the Item property or equivalently include an index in parentheses. For example, both Rows(1) and Rows.Item(1) return the first row of the active sheet.

Dim rngRows As Range
Set rngRows = ActiveSheet.Rows