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.

Visual Basic for Applications 
Worksheets("Sheet1").Activate If ActiveCell.HasArray =True Then MsgBox "The active cell is part of an array" End If
Find out if cell belongs to array has array Has Array Property HasArray HasArray property Is a particular cell included in an array? Return cell's array status.

See also: