HasArray Property

Applies To

Range Object.

Description

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

See Also

CurrentArray Property.

Example

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

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