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

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

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

Keywords :
Version :
Platform :
Issue type :