Controls which cells in an array should be treated as missing.
This property controls which cells in an array are treated as missing.
If the FillArray property is set
to a value other than None
, then these cells will be filled
with a default value.
CellUseDefault may include any, all or none of the following flags:
Flag | Description |
---|---|
MissingOrEmpty | Cells that are empty are considered to be missing. |
Blank |
Blank cells are considered to be missing. This
would include a cell containing ="" .
|
Zero | Numeric cells with zero values are considered to be empty. |
Nonnumeric | Non-numeric cells are considered to be empty. |