Excel: Example for NAMES() Function Returns #VALUE!

ID: Q88846

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 "Microsoft Excel Function Reference," version 4.0 contains the following example. This example is incorrect. 


   NAMES(3,"P*")


MORE INFORMATION

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


   NAMES(,3,"P*")


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


REFERENCES

"Microsoft Excel Function Reference," version 4.0, page 283

Additional query words:

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 26, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.