Excel Err Msg: 'Macro Error at Cell' with Clipboard Functions

 Last reviewed: November 30, 1994
Article ID: Q93540
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 3.0
  • Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0

SUMMARY

When you run a macro containing a function that uses the Clipboard, you may receive the following error message: 

   Macro error at cell: xxx
In version 4.0 for example, a macro that contains functions such as PASTE.SPECIAL(), PASTE(), PASTE.LINK, and PASTE.PICTURE, may return this error message if you run the macro by choosing Run from the Macro menu, selecting the macro, and then choosing the OK button. In version 5.0 this is also true, but you choose Macro from the Tools menu, select Run, then choose the OK button.

MORE INFORMATION

When you choose Run from the Macro menu, any information that is currently being stored in the Clipboard is removed. Therefore, macro functions that use the clipboard, such as the PASTE.SPECIAL() macro function, may return an error message when you run the macro by choosing Run from the Macro menu.

To run the macro without deleting the contents of the Clipboard, assign the macro to a shortcut key, a button, or tool bar tool. Running a macro with shortcut keys, buttons, and tool bar tools will allow you to use clipboard functions without generating the error message mentioned above.

REFERENCES

"Online Help," version 5.0 "User's Guide 1," version 4.0, pages 116, 117, 360-361 "User's Guide 2," version 4.0, pages 167, 177 "Function Reference," version 4.0, pages 315-319

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00
4.0 4.00 4.0a 4.00a 5.0 5.00 Paste Paste.Link Paste.Picture
Paste.Picture.Link Paste.Tool

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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.