Microsoft KB Archive/89714

{|
 * width="100%"|

Excel: Error Running Recorded Macro That Creates Chart Object

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
In Microsoft Excel for the Macintosh, when recording a macro that creates a chart object, the resulting macro places a CANCEL.COPY command immediately after the COPY command and preceding the CREATE.OBJECT command. CREATE.OBJECT reads information from the Excel Clipboard to create the chart object. Since CANCEL.COPY clears the Excel Clipboard, CREATE.OBJECT has no information with which to create the chart and a macro error results.

Workaround
The purpose for the CANCEL.COPY command is to clear the copy marquee. This command should be placed after the CREATE.OBJECT command to allow the macro to execute properly. When recording the same macro in Excel for Windows, the CANCEL.COPY command is correctly placed after CREATE.OBJECT.

Microsoft is researching this problem and will post new information here as it becomes available.

Reference(s):

&quot;Microsoft Excel Function Reference,&quot; version 4.0, pages 45, 77-79

Additional query words: 4.00

Keywords : kbprg

Version :

Platform :

Issue type :

Technology :