Error 1004: ActiveSheet.Shapes.AddChart.Select

Hey there,

i'm having a problem which drives me nuts. I have the following code:

Please Login or Register  to view this content.

it worked fine, but all of the sudden, it stopped with the runtime error 1004 at the line "ActiveSheet.Shapes.AddChart.Select"

so, whatever i try, i am not able to produce a chart anymore.
anyone has any suggestions? i've look through a lot of other threads, but nothing worked for me...

thanks a lot

EDIT: Strange thing i just noticed: when i add a chart manually, and then run the script again, it works all fine...

You should probably post all the code, not just where the problem starts.

Well I can't figure it out, but I did find a lot of other threads and hits on Google when I typed "activesheet.shapes.addchart.select error 1004"

Other Excel Forum Thread

I'm not much of a chart expert, but it seems like this problem has been noticed by quite a few people, hopefully you will find an answer.

Good Luck!!!