MLMissingDataAsNaN
Set empty cells to NaN
or 0
Syntax
= MLMissingDataAsNaN(flag)
MLMissingDataAsNaN flag
out = MLMissingDataAsNaN(flag)
Description
= MLMissingDataAsNaN(
sets
empty cells to flag
)NaN
or 0
. When
the Spreadsheet Link™ software is installed, the default is "no"
,
so empty cells are handled as 0
s. If you change
the value of MLMissingDataAsNaN
to "yes"
,
the change remains in effect the next time a Microsoft®
Excel® session
starts. Use this syntax when working directly in a worksheet.
MLMissingDataAsNaN
sets
empty cells to flag
NaN
or 0
. Use
this syntax in a VBA macro.
lets
you catch errors when executing out
= MLMissingDataAsNaN(flag
)MLMissingDataAsNaN
in
a VBA macro. If MLMissingDataAsNaN
fails, then out
is
a string containing error code. Otherwise, out
is 0
.
Input Arguments
|
Either Specify Default: |
Output Arguments
|
|
Examples
Tips
A string in an Excel range always forces cell array output and empty cells as
NaN
s.To work with VBA code in Excel with Spreadsheet Link, you must enable Spreadsheet Link as a reference in the Microsoft Visual Basic® Editor. For details, see Installation.