CurrentArray Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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