[RESOLVED] Excel VBA: finding the first row in a Range

Printable View

Jul 10th, 2008, 02:11 AM
wimfrits

[RESOLVED] Excel VBA: finding the first row in a Range

I want to determine the rownumber of the first cell in a Range. What would be the best way to do that?

Range.row seems to yield the correct number but I'm not sure if that is reliable.
Another way would be to use a combination of Range.rows.count and Range.Cells.SpecialCells(xlCellTypeLastCell).Row but that seems much too complicated.
Jul 10th, 2008, 04:01 AM
westconn1

Re: Excel VBA: finding the first row in a Range
vb Code:
```
firstrow = range("a9:f99").row
```

All times are GMT -5. The time now is 05:49 PM.