XLL+ Class Library (6.3)

Argument.CellUseDefault

Controls which cells in an array should be treated as missing.

Remarks

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.

See Also

Argument Model | Argument Properties