T
tom
I have created six embedded graphs on a worksheet. I need
to create the same six graphs on each of 120 other
worksheets in the workbook. Since Excel turns graph
functions off when you group pages, I am using a macro to
copy the original set of graphs (as a group) to the pages
and then to ungroup the graphs and edit the data series to
include the data from the appropriate sheet.
The macro returns a run time error stating
that "method 'xvalues' of object 'series' failed"
Excel then encounters a problem and shuts down.
If I change my macro to loop For i = 1 to 10...Next i,
instead of For i = 1 to 120, the macro runs fine.
I have gone back to doing this manually, and after
succesfully copying the group of charts to the first ten
sheets, the paste command on the eleventh sheet returns an
error that says 'no more new fonts may be applied in this
workbook'.
Is there some sort of limit within Excel that I am
exceeding? Any ideas on what might be happening? and what
the solution is?
Thanks.
to create the same six graphs on each of 120 other
worksheets in the workbook. Since Excel turns graph
functions off when you group pages, I am using a macro to
copy the original set of graphs (as a group) to the pages
and then to ungroup the graphs and edit the data series to
include the data from the appropriate sheet.
The macro returns a run time error stating
that "method 'xvalues' of object 'series' failed"
Excel then encounters a problem and shuts down.
If I change my macro to loop For i = 1 to 10...Next i,
instead of For i = 1 to 120, the macro runs fine.
I have gone back to doing this manually, and after
succesfully copying the group of charts to the first ten
sheets, the paste command on the eleventh sheet returns an
error that says 'no more new fonts may be applied in this
workbook'.
Is there some sort of limit within Excel that I am
exceeding? Any ideas on what might be happening? and what
the solution is?
Thanks.