Unable to set properties of series class - Clear all series information?

I am having some problems with one of my workbooks. The original file seems to work fine, but when I move it, sometimes I get Run-Time error '1004' some times I don't.

The problem arises when I try to change any of the .SeriesCollection values. In my workbook when I run my macro, it will fail at .SeriesCollection(1).Name = "10 Passes". Chart 2 already exists with 6 series' already defined. It seems that when I manualy go through and delete all the information out of each series (ie Right Click -> Source Data -> Series and delete name and set X and Y values to zero) the macro will run just fine.

Would it be best to:
1. Delete each series in each chart, then recreate them each time, or
2. Delete all the series information out of each SeriesCollection each time I run the macro?
Or is there some setting I need to change, or code to add to make it work correctly?

Please Login or Register  to view this content.

I am stumped. I fail to understand how it can work perfectly one minute, but when I move it, it fails. It should also be noted that I have no external links in my project.

Hope someone can help!

Thanks,

Eric

It is possible that there are empty cells in the series as there might not be as much data in the series as there would have been previously. The only one that confuses the heck out of me is when .Name = some text value that isn't a variable and I am still unable to change it and get runtime error. Is there a way to clear out the series before I populate it again? I have tried .Name/.Values/.XValues = "" and was unsuccesful. Right now I just cleared everything out of all the series manually and saved it like that read-only which works for me, but I am worried someone in the future will edit it and have the same problem as I have now.

This is what I get when I do a macro when I manually clear it out

Please Login or Register  to view this content.

Which is funny because If I put this exact code in my original module/macro, it will fail.

I believe I used a scatter plot with connecting lines. I will try changing it, then changing it back and see what happens.

Thanks,

Eric