Range.CountLarge Property (Excel)

Returns a value that represents the number of objects in the collection. Read-only Variant.

Version Information

Version Added: Excel 2007

Syntax

expression .CountLarge

expression A variable that represents a Range object.

Remarks

The CountLarge property is functionally the same as the Count property, except that the Count property will generate an overflow error if the specified range has more than 2,147,483,647 cells (one less than 2048 columns). The CountLarge property, however, can handle ranges up to the maximum size for a worksheet, which is 17,179,869,184 cells.

See Also

Concepts

Range Object

Range Object Members