Activating a Chart in VBA

[ZEvans12]

I'm creating a chart in VBA. I have it looping through all my data, and puting the correct information into the correct series. At the very end, I am trying to move this chart into a new tab with this code

Please Login or Register  to view this content.

I get an error, basically telling me that I can't do that because the chart isn't selected, so there is not "activechart" to reference.

Then I go back to the beginning where I add a new chart and enter this,

Please Login or Register  to view this content.

And at the end of the document then put,

Please Login or Register  to view this content.

However, it never gets to the last part of code, because at the line

ActiveChart.Name = "(0C)"

I get an error message that says Run-Time Error 7 "Out Of Memory"


All I need to do is somehow activate that graph, and then move it to a new tab at the very end of the macro. Any help would me greatly appreciated.

Thanks

P.S- I know my names don't all match up.. They do in my VB code, I was just creating a quick example in this document to explain the error I am getting.

[TMS]

Why not paste the sample workbook with some typical data/chart and your code ... so everything does match up and the problem can be seen in context.

Regards

[Andy Pope]

to name the chartobject you need

Please Login or Register  to view this content.

Why add the chartobject to a sheet and then move it?
Why not simply add a chart.

[ZEvans12]

If I were to add a new chart in the new tab, then I would have to reference the original worksheet when I collected me data, and then re-reference the chart at the end. Just seemed like an unnecessary step in my opinion. But the .parent code worked perfectly. Thank you.