• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1430
  • Last Modified:

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.

 Chart 1 shown, but not found, what gives?
1 Solution
Dave BrettVice President - Business EvaluationCommented:
Normally it would be

ActiveSheet.ChartObjects("Chart 1").Activate
in single quotes, not "Chart"""

Else pls post your file


AndyPandyAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now