ActiveChart.Name wont work.....

[chedges]

Please Login or Register  to view this content.

The last command wont name the chart, any ideas?

Thanks

[chedges]

I've worked out why it doesn't work but I dont know the solution.

Following on from the code above I then have this line:

Please Login or Register  to view this content.

Which reverts the name of the chart back to whichever chart number its on.

Any ideas how to get around this?

[Leith Ross]

Hello chedges,

It isn't clear to me what your problem is. Did you receive an error message or did the code fail to produce the chart?

Sincerely,
Leith Ross

[chedges]

the code stops when it get to a line which uses the chart name.

In several lines I reference the chart, however each time the macro is run and a chart is produced the name changes.

Therefore to get around this, I name the chart as soon as it is created. But this line mentioned above seems to revert the chart back to its original name (eg Chart9)