Hi guys,

I've got a big block of data, and I'm writing a macro to create
series of graphs from it.

Currently, I have an intermediate sheet where I have the chart titles
series names, and data ranges (referring to the first sheet) that th
macro uses to dress up each new chart.

Finally, I have a template chart that people can use to settl
stylistic issues. Then, my macro copies each new graph from thi
template and inserts the proper titles etc from the intermediat
sheet.

The problem is that I run the macro and everything is going great unti
I reach 57 sheets (53 graphs). Then I get a "Copy method of Char
class failed" error. Even if I stop the debugger, I can't copy m
template chart one more time. I can add new charts, but can't copy m
template chart.

Thoughts?
Nic

--
Message posted from http://www.ExcelForum.com

Nick -

It might be a better approach to turn your chart template into a user
defined chart type. I've occasionally had problems when I've copied a
chart too much.

http://peltiertech.com/Excel/ChartsH...stomTypes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

St. Nick < wrote:

Hi guys,

I've got a big block of data, and I'm writing a macro to create a
series of graphs from it.

Currently, I have an intermediate sheet where I have the chart titles,
series names, and data ranges (referring to the first sheet) that the
macro uses to dress up each new chart.

Finally, I have a template chart that people can use to settle
stylistic issues. Then, my macro copies each new graph from this
template and inserts the proper titles etc from the intermediate
sheet.

The problem is that I run the macro and everything is going great until
I reach 57 sheets (53 graphs). Then I get a "Copy method of Chart
class failed" error. Even if I stop the debugger, I can't copy my
template chart one more time. I can add new charts, but can't copy my
template chart.

Thoughts?
Nick


---
Message posted from http://www.ExcelForum.com/