Microsoft KB Archive/63944

Excel: #VALUE! Returned from Code Resource with Data Type K PSS ID Number: Q63944 Article last modified on 01-26-1993 PSS database name: M_eXceL

2.20 3.00

MACINTOSH

Summary:

In the “ChangeK” example on pages 173 and 174 in the “Microsoft Excel Technical Reference for the Macintosh,” if the passed array contains a blank cell, the resulting array contains “#VALUE!”. To avoid this problem, use the following array formula. (In this example, the REGISTER statement is in cell A3.)

=CALL(A3,IF(B1:D2=&quot;&quot;,0,B1:D2))

This formula sends zeros instead of blanks to the code resource which will prevent the #VALUE! error.

If the resulting array needs to have blanks where the original array has blanks, use the following array formula:

=IF(B1:D2=&quot;“,”“,CALL(A3,IF(B1:D2=”&quot;,0,B1:D2))

This formula still sends zeros instead of blanks to the code resource. However, the surrounding IF statement returns blanks where the corresponding cells in the original array were blank.

The “Microsoft Excel Technical Reference for the Macintosh” was part of the Excel Developer’s Program which has been discontinued. New support programs are currently being put into effect to replace the Excel Developer Program. For more information call Product Support Services at (206) 635-7070.

Additional reference words: 2.20 3.00 DLL dynamic link library developer’s noupd

Copyright Microsoft Corporation 1993.