update series with name (name manager)

[barbuxa]

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

[shg]

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.

[barbuxa]

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

[shg]

What does

Please Login or Register  to view this content.

return?

[barbuxa]

The same error i've mentioned before