Skip to main content

Range.Count property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

Returns a Long value that represents the number of objects in the collection.



expression A variable that represents a Range object.


The Count property is functionally the same as the CountLarge 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.


This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection.

Sub DisplayColumnCount()
    Dim iAreaCount As Integer
    Dim i As Integer
    iAreaCount = Selection.Areas.count
    If iAreaCount <= 1 Then
        MsgBox "The selection contains " & Selection.Columns.count & " columns."
        For i = 1 To iAreaCount
            MsgBox "Area " & i & " of the selection contains " & Selection.Areas(i).Columns.count & " columns."
        Next i
    End If
End Sub

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>