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
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,
And at the end of the document then put,
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.
Bookmarks