Microsoft Knowledge Base

Excel: Paste List on Macro Sheets Has Five, Not Four, Columns
Last reviewed: September 12, 1996
Article ID: Q125950
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

Page 297 of some versions of the Microsoft Excel "User's Guide 1," version 4.0, states the following: 

   On a worksheet, the list of names occupies two columns, one for the
   names, and the other for the references. On a macro sheet, the list of
   names has two additional columns. The first of the additional columns
   indicates the macro type: 1 indicates a custom function, 2 indicates a
   command macro, and 0 indicates neither. The last column contains the key
   combination used to run the macro.
This information is incorrect. Macro sheets have THREE additional columns: the first indicates the macro type, the second indicates the key combination, and the third indicates the category. For example, if you paste names in cell A1 of a macro sheet, the pasted information would resemble the following:

A1: Name B1: References C1: Macro Type D1: Key combination E1: Category

KBCategory: kbusage kbdocerr
KBSubcategory:

Additional reference words: 4.00 4.00a



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.