error in Visual Basic

[jpalmeri]

I am getting a "run time error '1004': Method 'SeriesCollection' of object
'_Chart failed " where I can debug or cancel. When I select Debug,
"ActiveChart.SeriesCollection (2).Select is highlighted. What does this mean
and how do I correct it?

 

[Beth Melton]

It means there is a macro (created by you or a third party - not Word) is
attempting to run at some point that is failing. The point it is failing is
ActiveChart.SeriesCollection(2).Select.

Are you actually working with a chart? What are you doing just prior to
encountering the error? Starting Word? Clicking a button?

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[jpalmeri]

I did not create the macro, however, the macro is designed to update
approximately 6 graphs with data from a chart of data. All of this is in an
excel file. I tried to run the macro from somebody else's PC and had the
same problem. I also tried to open up older versions of the same file and
still got the same error.

I do not know macros, in fact, have my first webinar tomorrow.

 

[Beth Melton]

Without knowing the actual code it's difficult to know where the problem
lies. Since this macro is one you actually want to use (many encounter macro
errors by unknowingly running a macro they don't want anyway) you might want
to post in one of the Word VBA (Programming) newsgroups in order to obtain a
wider audience of VBA users.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/