You can check that the cell values of the variables that appear in your UDF are accessible before you
use them in a computation by using the Data_Valid_P macro.
cxboolean Data_Valid_P()
Data_Valid_P is defined in the id.h header file, and is included in udf.h. The function returns 1
(true) if the data that is passed as an argument is valid, and 0 (false) if it is not.
回复此楼
