2007 compatibility

[Bob Phillips]

Does Worksheet.UsedRange.Rows.Count cause any issues?

No it won't. It is unlikely that UsedRange would be all rows, and even if it were it would not be a problem as Count is a Long, so it caters for 1M+ rows easily.

However, Worksheet.Cells.Count is a different matter. We are talking 17Billion+ cells here and that overflows Count significantly. Becuase of this, 2007 as an extra property, CountLarge, which returns the answer.

Interestingly, type

?TypeName(Activesheet.Rows.Count)

in the immediate window, and it tells you it is a long. Type

?TypeName(Activesheet.Cells.CountLarge)

and you get a Compile Error.