XL2000: Macro Error Running Recorded Paste Commands (199953)

SYMPTOMS

When you run a recorded macro that contains copy and paste commands, you may receive the following error message:

Microsoft Visual Basic

Run-time error '1004': Paste method of Worksheet class failed

CAUSE

This error message occurs when you do the following:

You start the macro recorder and you cut or copy items.

-and-
You paste using the Clipboard toolbar.

WORKAROUND

When recording macros, do not use the Clipboard toolbar to cut, copy or paste items. Instead use the Cut, Copy and Paste buttons on the Standard toolbar or the Edit menu.

MORE INFORMATION

When you perform multiple copy commands in any of the Microsoft Office programs, the Clipboard toolbar appears, allowing you to collect and paste multiple items stored in the toolbar. For example, you can copy a chart in Excel, switch to Microsoft Word and copy text, and then switch to Microsoft PowerPoint and paste all of the collected (cut or copied) items from the Office Clipboard.

However, because the Office Clipboard is not included in the Visual Basic for Applications object model, it is not a programmable object in Excel. Therefore, the macro recorder does not recognize actions performed with the Office Clipboard.

REFERENCES

For more information about the Office Clipboard, click Microsoft Excel Help on the Help menu, type About collecting and pasting multiple items in the Office Assistant or the Answer Wizard, and then click Search to view the topic.