Range.HasArray (Excel)

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

Dim booHasArray As Boolean
booHasArray = ActiveCell.HasArray