HasArray Property

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.

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

expression.HasArray

expression   Required. An expression that returns a Range object.

Remarks

Use the CurrentArray property to determine the the cells that are part of the current array.

Example

This example determines whether the active cell in Spreadsheet1 is part of an array. Is so, the array is selected.

  If Spreadsheet1.ActiveCell.HasArray Then _
     Spreadsheet1.ActiveCell.CurrentArray.Select