| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does hasarray return null rather than false?
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 wrote in message ... 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return null | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Have DGET return Null instead of #Value! | Excel Worksheet Functions | |||
| return a " " for null values | Excel Worksheet Functions | |||
Threaded Mode
