Excel 2003 Charts

K

KnightSurfer

Greetings,

Heres a challenge, i cant find a solution to this anywhere.

In EXCEL.

Ive got VB code to copy a Template of a Chart, and then populate it with data.
It needs to create about 40-45 graphs... i do this every monday so its
automated for that reason.

anyway, if it creates over around 39 graphs, i get this error:
-----
Run-time error '1004'
copy method of Chart class failed.
-----

This is the line of code is stops on.

Sheets("TEMPLATE").Select
Sheets("TEMPLATE").Copy after:=Sheets(Sheets.Count)

Sheets("TEMPLATE (2)").Select
Sheets("TEMPLATE (2)").Name = KPR_Sheet

-------

Any help would be great.

if i save and close the spreadsheet, it seems to reset the error. ie if i
restart it after i have opened it, i can get another 40 odd sheets before it
fails.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL 2003 - Run Time Error... want a challenge ! 2
Excel 2003 - VB Code - Run time error....pls help :( 4
Need Help with a VBA subroutine 0
Charts in Multiple Sheet in Excel 1
Chart deselect question - Before Print 1
Chart data references not changing to new tab when worksheet is co 1
Odd Chart Format Results 1
How come when I try to insert a chart in Excel, nothing happens? 2

Top