Export (0) Print
Expand All
Expand Minimize

Range.HasArray Property

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

Syntax

expression.HasArray

expression   A variable that represents a Range object.

Example

This example displays a message if the active cell on Sheet1 is part of an array.

Visual Basic for Applications
Worksheets("Sheet1").Activate
If ActiveCell.HasArray =True Then
    MsgBox "The active cell is part of an array"
End If



Community Additions

ADD
Show:
© 2014 Microsoft