Link to home
Start Free TrialLog in
Avatar of AndyPandy
AndyPandyFlag for United States of America

asked on

Excel Error on ActiveSheet.ChartObjects("Chart 1""").Activate

Hi Experts,

How to fix this?
The image below shows the error I get when the macro attempts the line:
ActiveSheet.ChartObjects("Chart 1""").Activate
"Chart 1" is shown on the worksheet, as can be seen,
yet the macro cannot find it (stupid macro).
Google shows this is a common question, yet I haven't found a answer.

 User generated image
ASKER CERTIFIED SOLUTION
Avatar of Dave
Dave
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AndyPandy

ASKER

Yes,  I found that same thing just after posting the question.  
The Macro recorder put those extra quotes in,  I do not know why.
Thank you