I am losing my ActiveChart.Name

**mattdick** · 04-29-2009, 05:30 PM

Excel 2007

I'm trying to name the chart in my macro so the next time I run the macro I can delete the old chart. I use:

Please Login or Register  to view this content.

And so on, and *right* after this stretch of code runs I can use the immediate window to print it and I get the generic name.

Print ActiveChart.Name
StatPack Chart 28

Any idea why this is happening? There is only one thing I can think of at this point, and that is that when I set up the chart, I pull it back from its own sheet to the current "StatPack" worksheet using this:

Please Login or Register  to view this content.

Is it possible that the chart moving out and back has it's name changed?

**Andy Pope** · 04-30-2009, 08:53 AM

If the active chart is a chart object then try this code instead.

Please Login or Register  to view this content.

**mattdick** · 04-30-2009, 11:19 AM

Thank you, you forced me to try this again. I'd done it once and had gotten an error (something like "no such object in this context"). As it turns out, I had called "ActiveChart.Parent..." prior to placing the chart back in the worksheet. So when it's a chart on its own tab, apparently there is no parent.

Or at least this tracks with what I was seeing.

Thanks again.

**Andy Pope** · 05-01-2009, 09:24 AM

Technically there is a parent for a chart sheet, it's the workbook.

In your example "StatPack Chart 28" is the charts name. When dealing with chartobjects you need the ChartObject name, which is when you use the Parent property to find it if using the Activechart object.