Excel: Duplicate NOTE or DEFINE.NAME in Recorded Macro

Last reviewed: September 2, 1997
Article ID: Q81567

SUMMARY

Duplicate NOTE() or DEFINE.NAME() macro functions may appear in recorded macros when only one note or name is added. This does not adversely affect the functionality of a recorded macro, but it does decrease its execution speed slightly.

To avoid this behavior while recording a macro, choose OK without choosing Add when defining a single name, or adding a single note. If you are defining more than one name or note, choose Add for all except the last note or name, then choose OK after the last one.

If duplicate functions are inadvertently recorded, just delete the duplicates.

MORE INFORMATION

The NOTE() and DEFINE.NAME() functions are recorded when you choose either Add or OK. This is to allow recording the definition of multiple names or notes before closing the dialog box.


Additional query words: 4.00
Keywords : PgmOthr


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 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.