Solved

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

Posted on 2011-02-20
2
1,074 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:AndyPandy
2 Comments
 
LVL 50

Accepted Solution

by:
Dave Brett earned 500 total points
ID: 34940054
Normally it would be

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

Else pls post your file

Cheers

Dave
0
 

Author Closing Comment

by:AndyPandy
ID: 34940153
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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

937 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now