Excel 2010 VBA Excel Chart Name

[jjlafond]

Hello,

I am creating several charts using VBA in Excel 2010, but I need to be able to reNAME the chart so that I can reference it in later lines. However, each time I create a new chart, the Chart is automatically named (Chart 1, Chart 2, Chart 3, Chart 4...) and I have to manually change the name to allow the code to work.

Is there a way to name the chart when creating it without physically looking at the chart name and editing manually?

 

[VoG]

Maybe try

ActiveSheet.ChartObjects(ActiveSheet.ChartObjects.Count).Name = "Fred"

 

[jjlafond]

You are a lifesaver, works perfectly. Thank you!