Microsoft KB Archive/88846

{|
 * width="100%"|

Excel: Example for NAMES Function Returns #VALUE!

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
Page 283 of the &quot;Microsoft Excel Function Reference,&quot; version 4.0 contains the following example. This example is incorrect.

  NAMES(3,&quot;P*&quot;)

MORE INFORMATION
The example given in the manual returns a #VALUE!. The corrected line should read:

  NAMES(,3,&quot;P*&quot;)

The leading comma is necessary unless a document name is specified.