Skip to main content

Range.CountLarge property

Table of contents
  1. Syntax
  2. Remarks

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



expression A variable that represents a Range object.


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 2,048 columns). The CountLarge property, however, can handle ranges up to the maximum size for a worksheet, which is 17,179,869,184 cells.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>