Skip to main content

Range.CurrentArray property

Table of contents
  1. Syntax
  2. Example

If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only.



expression A variable that represents a Range object.


This example assumes that cell A1 on Sheet1 is the active cell, and that the active cell is part of an array that includes cells A1:A10. The example selects cells A1:A10 on Sheet1.


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>