Skip to main content

Range.HasArray property

Table of contents
  1. Syntax
  2. Example

True if the specified cell is part of an array formula. Read-only Variant.



expression A variable that represents a Range object.


This example displays a message if the active cell on Sheet1 is part of an array.

If ActiveCell.HasArray = True Then
    MsgBox "The active cell is part of an array"
End If

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>