This project has moved. For the latest updates, please go here.

Getting count of Rows in column

Jan 6, 2014 at 4:12 PM
Is there a method to use to obtain the count of rows in a column? If so, what is the best approach?

I am working to read a column and then add a formula to each row in the next column but need to know how many rows to run through.
Coordinator
Jan 6, 2014 at 5:49 PM
A column doesn't have "rows", it has cells. You can simply do range.Column(1).Cells().Count()
You can even skip the column and ask for the rows in the range: range.Rows().Count()