Excel.Range.HasArray.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.HasArray property (Excel)	vbaxl10.chm144142	vbaxl10.chm144142	Excel.Range.HasArray	fac17206-8671-6209-9133-d56da6ea2b9c	05/11/2019	medium

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

[!includeSupport and feedback]