Formula Functions / Functions A to C / ANCHORARRAY
ANCHORARRAY

This function returns the entire spilled range for the dynamic array in cell.

Syntax

ANCHORARRAY (cell)

Argument

ANCHORARRAY function has the following argument:

Argument Description
Cell [Required] Specifies the cell that contains the dynamic array.

Data Types

Returns the spilled range.

Version Available

This function is available in product version 13.0 or later.