Excel: Macro Recorder Generates Error with Embedded ChartLast reviewed: September 2, 1997Article ID: Q78471 |
The information in this article applies to:
SYMPTOMSYou can record a macro to create an embedded chart on your worksheet based on your current selection. However, if your current selection is non-linear, you will receive the error "Cannot do that command on a multiple selection" when attempting to run the macro.
STATUSMicrosoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in version 5.0 of Microsoft Excel for Windows.
MORE INFORMATIONCREATE.OBJECT is the macro command that is used to draw objects on a worksheet. If it is used to create a chart, it must be preceded in the macro by the COPY command. However, you cannot copy a non-linear selection. Note: A linear selection is one that is aligned either vertically or horizontally.
Steps to Reproduce Problem
WORKAROUNDTo correct the problem, you must do either of the following while recording the macro:
linear and aligned and excel REFERENCES"Microsoft Excel Function Reference," version 3.0, pages 40-41 Additional query Words: 3.00 4.0 4.00 Keywords : kbmacro kbusage PgmHowTo PgmOthr |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |