Microsoft KB Archive/93540

{|
 * width="100%"|

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

 * }

-

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.