Range.HasArray Property (Excel)
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.
Worksheets("Sheet1").Activate
If ActiveCell.HasArray =True Then
MsgBox "The active cell is part of an array"
End If