Why does hasarray return null rather than false?

[Guest]

If I check the hasarray property on a range containing
two cells that both have array formulas, the result is
TRUE.

If I check the hasarray property on two cells where one
has an array formula and the other does not, the result
is null rather than false. Why?

Thanks for the help.

 

[Chip Pearson]

A Null value in a variant variable means that the variable
contains no meaningful data. If one cell has an array formula and
the other does not, the result of HasArray can be neither True
nor False and still be accurate. The function returns Null
meaning that there is no meaningful data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com