Run-time error '438': - trying to delete a chart but code is failing

[bishoposiris]

I'm running the following the code:

Please Login or Register  to view this content.

The problem is with these two lines:

Please Login or Register  to view this content.

If I comment out these lines the code works fine. If I run it with these two lines, the first line deletes the chart but I get the error and it hangs up at that line. I have this procedure assigned to a button on a separate sheet. If I run it once (with those lines commented out) I have no problems. If I run it a second time (with the lines commented out), however, the first chart is still there and the second chart gets messed up. What I'm trying to do is delete the first chart before making the second one. How do I do this?

[Greg M]

Hi there,

Try replacing part of your code with the following highlighted lines:

Please Login or Register  to view this content.

Obviously I don't have any data with which to fully test the code, but I seem to be able to create and delete "empty" graphs as required.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[bishoposiris]

I did what you said and added the following code:

Please Login or Register  to view this content.

I get "Run-time error '1004': Application-defined or object-defined error" at this line:

Please Login or Register  to view this content.

[Greg M]

Hi again,

Did the worksheet contain a ChartObject (graph) when you ran the code?

If you wish to run the routine when the worksheet contains no ChartObject (e.g. the first time the routine is run) you should add the following highlighted lines:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[bishoposiris]

I ended up solving this problem with the following code:

Please Login or Register  to view this content.

[Greg M]

Hi again,

Many thanks for that interesting and useful feedback - it just goes to show that in Excel there's always more than one way to skin a cat!

Thanks also for the Reputation increase - much appreciated

Best regards,

Greg M