+ Reply to Thread
Results 1 to 5 of 5

update series with name (name manager)

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Luxembourg
    MS-Off Ver
    2010
    Posts
    3

    update series with name (name manager)

    Hi

    I am not a excel or VBA expert, but the project demands that i try ...

    I have a chart where the series are populated acordingly to the value present in names (name manager), for instance series values ='Projet test'!finished

    i created a macro to copy a row (keeping the formulas of the last one), but the chart is not updated because the series values switchs from the previous sentence to something like ='Projet test'!$AH$2:$AH$26.

    So i am trying to update the value of the series after adding the row, in order to "update" to the correct name, but with no sucess. Can you please help me understand if this is possible? The code i got is:

    Please Login or Register  to view this content.
    Thanks in advance for your help!

    Bárbara
    Last edited by barbuxa; 09-26-2014 at 02:38 AM. Reason: COD TAGS

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: update series with name (name manager)

    Try

    Please Login or Register  to view this content.
    Please take a few minutes to read the forum rules, and then edit your post to use CODE tags.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-22-2014
    Location
    Luxembourg
    MS-Off Ver
    2010
    Posts
    3

    Re: update series with name (name manager)

    Hi, thanks for the help

    i get the following error message for the code you send:
    Run-time error '1004': Application-defined r object defined error.

    Any idea?

    Thanks

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: update series with name (name manager)

    What does

    Please Login or Register  to view this content.
    return?

  5. #5
    Registered User
    Join Date
    07-22-2014
    Location
    Luxembourg
    MS-Off Ver
    2010
    Posts
    3

    Re: update series with name (name manager)

    The same error i've mentioned before

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple Time Series Update
    By tgreen104 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2013, 11:35 PM
  2. Update line chart series colors
    By Apple Ling in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-02-2010, 05:10 AM
  3. Dynamic range to update chart, multiple series
    By staples in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-31-2009, 12:26 PM
  4. automatically update results in series of columns
    By ktchegi in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 04-05-2007, 07:07 AM
  5. can't update chart series unless its activated
    By Woody in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2005, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1