Dynamically Delete Chart ??

.

Please Login or Register  to view this content.

The above is the portion of existing code that selects a range (after searching and locating a specific term related to the range) and deletes everything in the range,
then SHIFTS those rows (only the selected cells) up. In most cases, there is other existing data located below the selected area.

Randomly, Excel is leaving a replacement Chart that doesn't correspond to anything. It just simply appears. Weird !

So, what is wrong with the existing code ...

Thanks for your assistance.

.
Ok .. I've been doing some deeper research into the existing. It is not doing exactly what I believed.

Presently the code is not selecting the chart ... which is what I previously believed.

So ... the primary problem is : How do I select a chart that is in a range of cells that have been dynamically selected (.SELECTION) ... WITHOUT using the chart name ?

In other words .. whatever chart happens to exist in the selected range ?


Thanks.

ps: everything I've located, all specifically name a chart.

.
As depicted in the image, the single correct chart has been selected. I've gotten this far. But I can't get it deleted using either Selection.Delete or Selection.Cut .

Here is the macro that manages to get the correct chart selected ...

Please Login or Register  to view this content.

Here is an image showing the sheet up to the point of the above macro completion. As you can see, only the targeted chart has been selected.

Chart Select.jpg

.
Thanks.

This has me stumped.

.
Ok ... I believe I have my answer. Need to test it several more times to verify it works.

A different macro, when the chart is created, writes the Chart Name to a cell that will be covered by the chart.

Then, when the user executes the macros to delete the table, several other ranges and finally the chart, the following identifies the chart name
then deletes the chart.

Please Login or Register  to view this content.

The above macro utilizes the following Function as well :

Please Login or Register  to view this content.

Thank you all for your assistance. Your comments led me to the solution.