HasArray Property

Microsoft Office Web Components Visual Basic

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