Number of rows in a worksheet

May 29, 2011 at 5:23 PM

I need to be able to iterate through a worksheet and determine the number of rows used. Since some of the rows can be blank, I can't just look for the first unused row. I don't see any kind of property about the number of rows (like a Rows.Count or RowCount in the Worksheet object). What is the best way without iterating to infinity?

Thanks in advance,

-Ron B.

May 29, 2011 at 5:29 PM

look at this thread

May 29, 2011 at 5:30 PM