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.

If ActiveCell.HasArray =True Then 
 MsgBox "The active cell is part of an array" 
End If

Community Additions

© 2014 Microsoft