OK, I am finishing up an add-on project for a legacy Excel-VBA application, and I have once again run up against the conundrum of the mysterious `range.Rows` (?) and `worksheet.Rows` properties.  

Does anyone know what these properties really do and what they are supposed to provide to me?  (Note: all of this probably applies to the corresponding `*.Columns` properties also).

What I would really *like* to be able to use it for is to return a range of rows, like this:

       SET rng = wks.Rows(iStartRow, iEndRow)

But I have never been able to get it to do that, even though the Intellisense shows two arguments for it.  Instead I have to use one of the two or three other (very kludgy) techniques.  

The help is very unhelpful (typically so for Office VBA), and googling for &quot;Rows&quot; is not very useful, no matter how many other terms I add to it.

The only things that I have been able to use it for are 1) return a single row as a range ( `rng.Rows(i)` ) and 2) return a count of the rows in a range ( `rng.Rows.Count` ).  Is that it?  Is there really nothing else that it&#39;s good for?

**Clarification:** I know that it returns a range and that there are other ways to get a range of rows.  What I am asking for is specifically what do we get from `.Rows()` that we do not already get from `.Cells()` and `.Range()`?  The two things that I  know are 1) an easier way to return a range of a single row and 2) a way to count the number of rows in a range.  

Is there anything else?


All Ole Automation Solutions on Gang of Coders

Total of 1 Ole Automation Solutions

What does the Excel range.Rows property really do?