CurrentArray Property

       

If the specified cell is part of an array, returns a Range object that represents the entire array. Results in a run-time error if the specified cell is not part of an array. Read-only.

expression.CurrentArray

expression   Required. An expression that returns a Range object.

Remarks

Use the HasArray property to determine whether or not a cell is part of an array.

Example

Assuming that the active cell is part of an array, this example selects the array.

Spreadsheet1.ActiveCell.CurrentArray.Select