Excel crashes when running a "delete" macro

[dmarx]

Hi everyone.

I am experiencing a quite strange problem with excel and I'll try to be as clear as possible.

I have some charts in one sheets that are made of clustered series and scatter ones (it's a normal bar-graph with a target line).

I have also a function that reset all the graphs:

Please Login or Register  to view this content.

Now, if in my graph I have just bars, the macro works perfectly. When I add to my graphs the target line (that I remember is a xlXYScatterLinesNoMarkers), excel crashes. I have tried in more than one pc so it is not a pc problem.

I have also tried to add a further check to that function

Please Login or Register  to view this content.

just to avoid scatter data, but it crashes anyway...

[dmarx]

I forgot to mention that if I run the macro step-by-step it works perfectly!