Expand Minimize

Range.HasArray Property (Excel)

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

expression .HasArray

expression A variable that represents a Range object.

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

Community Additions

ADD
Show:
© 2014 Microsoft