Range.HasArray property

ExcelBaby July 28, 2022 1 minute to read

6 0

Table of contents

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.

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